Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> IN vs. EXISTS ...... NOT IN vs. NOT EXISTS

IN vs. EXISTS ...... NOT IN vs. NOT EXISTS

From: Kal Khatib <kal_at_gene.COM>
Date: 1998/02/09
Message-ID: <34DFBE2D.17B38868@gene.com>#1/1

I have statements where i use the above oracle functions. IN and EXISTS seem _not_ to be interchangable (same for negation) Could some explain the differnece in behavior between those functions (beside performace.. IN is slower I think)?. I find it tricky to use one vs. the other. I end up having to experimenting with permutation
to get the logic right.
thanks
Kal.

--
http://members.tripod.com/~kalk
Received on Mon Feb 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US