ORA-00928: missing SELECT keyword
544878May 15 2007 — edited May 15 2007Can you please tell me, why i got an below error:
SQL> ed
Wrote file afiedt.buf
1 with tab as(
2 SELECT 1 AS ID, 'AAA' AS NAME FROM DUAL UNION ALL
3 SELECT 1 , 'BBB' FROM DUAL UNION ALL
4 SELECT 1 , 'CCC' FROM DUAL
5 )
6 SELECT ID, NAME from tab a WHERE ROWID >=(SELECT MAX(ROWID) FROM tab b where a.id=b.id)
SQL> /
with tab as(
*
ERROR at line 1:
ORA-00928: missing SELECT keyword
Thanks
Sathya