November 19th, 2011, 06:02 PM
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???
January 27th, 2012, 01:22 AM
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.
February 5th, 2012, 04:50 PM
Originally Posted by debasisdas
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?
February 6th, 2012, 12:53 PM
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.
April 27th, 2012, 07:17 AM
Kindly Read Oracle SQL documentation.