DaniWeb IT Discussion Community - Diff b/w not exists and not in at oracle

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Oracle (http://www.daniweb.com/forums/forum129.html)

- - Diff b/w not exists and not in at oracle (http://www.daniweb.com/forums/thread152319.html)

Diff b/w not exists and not in at oracle

hi

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

thanks

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

what did google say ?

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

Quote:

Originally Posted by balakrishnan.kb (Post 716756)

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...

:)