Home » SQL & PL/SQL » SQL & PL/SQL » IN vs. EXISTS
IN vs. EXISTS [message #300106] Thu, 14 February 2008 04:38 Go to next message
panda.ranjit
Messages: 2
Registered: September 2007
Location: Mumbai
Junior Member
sorry to disturb u,
i am just a beginner in oracle i just want to know about in vs exists and in which way i will get my query faster in all respect.
thanks and regards,
ranjit

[Topic SPLIT by LF]

[Updated on: Thu, 14 February 2008 06:47] by Moderator

Report message to a moderator

Re: pl/sql table vs nested table [message #300107 is a reply to message #300106] Thu, 14 February 2008 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand what you're asking.

Regards
Michel

[I didn't understand when it was merged inside another topic]

[Updated on: Thu, 14 February 2008 06:49]

Report message to a moderator

Re: pl/sql table vs nested table [message #300119 is a reply to message #300107] Thu, 14 February 2008 05:08 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
@panda.ranjit
you are hijacking someone else's post.choose a new thread to post your query.and as for your question regarding IN vs EXISTS performance wise there isn't much difference.you can refer this link

Link

regards,
Previous Topic: PL/SQL out parameter and Return
Next Topic: Which Approach is the Better
Goto Forum:
  


Current Time: Sat Dec 10 19:00:54 CST 2016

Total time taken to generate the page: 0.07821 seconds