code_junkie

What could cause an ORA-00936 - Missing Expression with the following sql?

Nov 12th, 2011
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. select (select count(*) from gt_roster where ROS_ROSTERPLAN_ID = RPL_ID)
  2. from gt_rosterplan
  3. where RPL_ID = 432065061
  4.  
  5. SQL> select (select count(*) from emp2 where empdeptno = deptno)
  6. 2 from dept
  7. 3 where deptno=10
  8. 4 /
  9.  
  10. (SELECTCOUNT(*)FROMEMP2WHEREEMPDEPTNO=DEPTNO)
  11. ---------------------------------------------
  12. 3
Add Comment
Please, Sign In to add comment