Hi Friends,
Can someone help me to find out what is wrong in the following sql? It is returning ORA-00933: SQL command not properly ended.
Thanks in advance
Manjunath
Printable View
Hi Friends,
Can someone help me to find out what is wrong in the following sql? It is returning ORA-00933: SQL command not properly ended.
Thanks in advance
Manjunath
where's the sql, i think you forgot to pase it :D
Sorry for the blunder.
SELECT /*+ Q43947000 NO_EXPAND ROWID(A1) */ A1."CLIENT_USER_ID",A1."PROFILE_ID",A1."REPORT_TYPE_ID",A1."SCHEDULE_TYPE",A1."START_TIME",A1."END_TIME" FROM "TDS_MANAGER"."REPORT_INSTANCE_TBL" PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1 WHERE A1."REQUEST_ID"=:B1
I think you should remove all the double quotes or is it a pasting error that I see quotes around all column names
The quotes do not matter. I copied the sql from 'top sessions' display, hence the quotes.