Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Unanswered: ORA-00933: SQL command not properly ended

    (Select BRINDEX
    from REZULTATI)
    EXCEPT
    (select BRINDEX
    FROM BARAREZ);

    I use this code and i think that is corect but i recive this massage

    ERROR at line 3:
    ORA-00933: SQL command not properly ended

    if somebody have idea or know what is wrong, please tell me..

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Please point me at the place in the SQL reference manual
    http://download-west.oracle.com/docs...a96540/toc.htm
    where "EXCEPT" is a valid keyword in the SELECT statement
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I imagine you mean MINUS, rather than EXCEPT?

    Select BRINDEX from REZULTATI
    MINUS
    select BRINDEX FROM BARAREZ;

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  4. #4
    Join Date
    Jan 2005
    Posts
    2
    IT's work with MINUS

    I have book for relation database , and in set operation is mentioned EXCEPT and in the book is exaple with except command....

    Thank you...

    Here you can see that EXCEPT work with sql, but not in oracle

    EXAMPLE
    Last edited by sage; 01-07-05 at 08:40.

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    There are many different flavours of SQL, the core ANSI standards even have different versions. Most vendors then have their own interpretations built around one of the ANSI flavours.

    The link you have is for "Adaptive Server Anywhere", you would be better to download the Oracle documentation for your version which will include all of the Oracle specific syntax and features. You might have to register (it's free).

    http://tahiti.oracle.com/

    Kind Regards
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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