Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators
Discuss Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators in the Oracle Development forum on Dev Shed. Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.
Receive the tools necessary to be the rock star of your field. Our 12-month program teaches you the evolving world of multi-channel marketing as well as the complex issues and opportunities found in the industry.
ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month! Download and Activate to enter!
Web development can be a daunting task, even for specialists. There is a lot of information to absorb and a lot of technologies to learn in order to manage a superior website. When trying to learn the ropes, developers need a reliable source to introduce new ideas that can be easily implemented. When working on large projects, even web veterans may run into a technology or an aspect of a technology that they are unfamiliar with.
Posts: 22
Time spent in forums: 8 h 18 m 57 sec
Reputation 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???
Posts: 22
Time spent in forums: 8 h 18 m 57 sec
Reputation Power: 0
Quote:
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?
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
