Oracle

Diff b/w not exists and not in at oracle

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2008

Posts: 24

Reputation: balakrishnan.kb is an unknown quantity at this point

Solved Threads: 0

balakrishnan.kb balakrishnan.kb is offline

Offline

Newbie Poster

Diff b/w not exists and not in at oracle

Oct 20th, 2008

hi

what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery

thanks

•

Join Date: Feb 2007

Posts: 2,068

Reputation: debasisdas will become famous soon enough

Solved Threads: 123

debasisdas debasisdas is offline

Offline

Postaholic

Re: Diff b/w not exists and not in at oracle

Oct 21st, 2008

what did google say ?

Share your Knowledge.

•

Join Date: Oct 2008

Posts: 1

Reputation: shrichandray is an unknown quantity at this point

Solved Threads: 0

shrichandray shrichandray is offline

Offline

Newbie Poster

Re: Diff b/w not exists and not in at oracle

Oct 31st, 2008

•

Originally Posted by balakrishnan.kb

hi

what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery

thanks

If you did not get your answer yet, then let me try to answer it in a brief...
Not Exists Check for one occurance in the Sub query and comes out and to use Not Exists you have to user subquery or co-related query.
Where in case of t Not In it chekc the condition again the set of values specified or returned by sub query....
If you can use Not eixts it is always better for performance...