ora-933
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ora-933

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    where's the sql, i think you forgot to pase it
    KN

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    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

  4. #4
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    I think you should remove all the double quotes or is it a pasting error that I see quotes around all column names
    KN

  5. #5
    Join Date
    Oct 2000
    Posts
    211
    The quotes do not matter. I copied the sql from 'top sessions' display, hence the quotes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width