OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql [message #372540]

Wed, 21 February 2001 02:12

Jey
Messages: 4
Registered: February 2001

Junior Member

hi,

what is the difference between IN and EXISTS. In which situation shall i use Exists?

Thanks in advance.

jey

Report message to a moderator

Re: sql [message #372541 is a reply to message #372540]

Wed, 21 February 2001 02:29

gvenkat
Messages: 8
Registered: February 2001
Location: DUBAI

Junior Member

IN is used to check for all the conditions , that is for more than one condition. It would return ALL rows which satisfy any one of the paratmeters in the statement.
Where as EXISTS is generally used to check for a particular condition and it would come out of query, once the condition is met!

If u r not clear, i will give u an example later.

bye
g magesh

Report message to a moderator

Re: sql [message #372561 is a reply to message #372540]

Thu, 22 February 2001 06:39

Marcus Fernando
Messages: 34
Registered: September 2000

Member

I would like. Would you please send me an example ?

Report message to a moderator

Previous Topic:	Insert into
Next Topic:	sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 05:27:08 CDT 2024