ORA-00933: SQL command not properly ended
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00933: SQL command not properly ended

  1. #1
    Join Date
    May 2003
    Posts
    18

    ORA-00933: SQL command not properly ended

    I must be blind. Does anyone have a clue??

    Code:
    SELECT DTE_SENT FROM DOCO.CORRESPONDENCE TO_DATE ('03-APR-2003','DD-MON-YYYY');
    Thanks!!

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Your not blind, that's not correct syntax for Oracle!

    What exactly are you trying to do?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,973

    Re: ORA-00933: SQL command not properly ended

    Originally posted by Kwj
    I must be blind. Does anyone have a clue??

    Code:
    SELECT DTE_SENT FROM DOCO.CORRESPONDENCE TO_DATE ('03-APR-2003','DD-MON-YYYY');
    Thanks!!

    Maybe I'm blind, but it it doesn't look anywhere close to compiling.
    Perhaps this is what you were thinking. I'm not sure what DTE_SENT is though.
    Code:
    SELECT DTE_SENT, TO_DATE ('03-APR-2003','DD-MON-YYYY')
    FROM DOCO.CORRESPONDENCE ;

  4. #4
    Join Date
    May 2003
    Posts
    18
    That was it, gandolf. Just a brain-sneeze on my end. Thanks everyone!!

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,973
    Originally posted by jovery
    Your not blind, that's not correct syntax for Oracle!

    What exactly are you trying to do?
    Hmmmm and I thought you were infallable.
    Last edited by gandolf989; 05-28-2003 at 03:27 PM.

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