#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    26
    Rep Power
    0

    Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators


    Hi guys, can anybody tell me where difference lies between these operators or clause, & whether there is any "except" operator in oracle, i know other three are used bt dont think oracle uses "except" too..as far as i have seen "NOT IN", "MINUS" , "NOT EXISTS" are exactly similar? pls correct me if am wrong, preferrable with any example???

    Thankss...
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    119
    No oracle does not support "except" for any set operation.

    and "NOT IN", "MINUS" , "NOT EXISTS" are not similar.

    You need to read books for details of all that.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    26
    Rep Power
    0
    Originally Posted by debasisdas
    No oracle does not support "except" for any set operation.

    and "NOT IN", "MINUS" , "NOT EXISTS" are not similar.

    You need to read books for details of all that.

    Hi, Thanks for reply...okay can you also confirm..i think these three 'not in' , 'minus', 'not exists' are syntactically different..but where one out of these three can be used to achieve a purpose,logically another can also be used with similar logic, only syntax or usage would be different?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    As debasisdas said: They are not the same and a good book on SQL will clarify the differences for you.

    If you are having difficulty with the logic of a specific SQL statement then do post it here
    together with a description of what it should be doing.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    3
    Rep Power
    0
    Hi,

    Kindly Read Oracle SQL documentation.

IMN logo majestic logo threadwatch logo seochat tools logo