Forums: » Register « |  Free Tools |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support |

New Free Tools on Dev Shed!

#1
November 19th, 2011, 06:02 PM
 Amukherji
Registered User

Join Date: Aug 2011
Posts: 26
Time spent in forums: 9 h 23 m 15 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???

Thankss...

#2
January 27th, 2012, 01:22 AM
 debasisdas
Humble Learner

Join Date: Jul 2007
Location: Bangalore, India
Posts: 280
Time spent in forums: 2 Months 3 Days 5 h 8 m 31 sec
Reputation 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.

#3
February 5th, 2012, 04:50 PM
 Amukherji
Registered User

Join Date: Aug 2011
Posts: 26
Time spent in forums: 9 h 23 m 15 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?

#4
February 6th, 2012, 12:53 PM
 clivew
Contributing User

Join Date: Jan 2006
Posts: 2,047
Time spent in forums: 1 Week 6 Days 3 h 34 m 18 sec
Reputation Power: 382
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.

#5
April 27th, 2012, 07:17 AM
 kimipatel
Registered User

Join Date: Apr 2012
Posts: 3
Time spent in forums: 2 h 50 m 33 sec
Reputation Power: 0
Hi,

 Viewing: Dev Shed Forums > Databases > Oracle Development > Difference between NOT IN,MINUS,NOT EXISTS and EXCEPT operators