Home » SQL & PL/SQL » SQL & PL/SQL » Need Help in Advance Subqueries (Exists,With .Correlated Subquery) (SQL PLUS 10G)
Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590441] Thu, 18 July 2013 05:28 Go to next message
JEETUORAFAQ
Messages: 4
Registered: July 2013
Location: India
Junior Member
Someone make me understand the concept of Exists, With and Correlated Subquery in Sql plus 10g from begining, what are they how do they work with step by step example from basic.
Thanks.

[Updated on: Thu, 18 July 2013 05:29]

Report message to a moderator

Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590443 is a reply to message #590441] Thu, 18 July 2013 05:32 Go to previous messageGo to next message
dariyoosh
Messages: 510
Registered: March 2009
Location: Iran / France
Senior Member
Hi,

Didi you do any search in the online documentation?

As an example:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/conditions012.htm#SQLRF52167

http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10002.htm#i2077142


Regards,
Dariyoosh
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590467 is a reply to message #590441] Thu, 18 July 2013 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/139482/589485/102589/#msg_589485

Regards
Michel
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590473 is a reply to message #590467] Thu, 18 July 2013 07:11 Go to previous messageGo to next message
JEETUORAFAQ
Messages: 4
Registered: July 2013
Location: India
Junior Member
Thank you both for replies but The examples given there are not enough to understand the whole concept.
if possible then give your own example with expanation , dont copy from somewhere
Thanks
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590474 is a reply to message #590473] Thu, 18 July 2013 07:18 Go to previous messageGo to next message
dariyoosh
Messages: 510
Registered: March 2009
Location: Iran / France
Senior Member
JEETUORAFAQ wrote on Thu, 18 July 2013 14:11
Thank you both for replies but The examples given there are not enough to understand the whole concept.
if possible then give your own example with explanation

Maybe you should first say how much did you read about it in those links?

JEETUORAFAQ wrote on Thu, 18 July 2013 14:11
dont copy from somewhere . . .

Online documentation = Official Reference

So if you have a problem with one of the examples, you should say, which one? what do you understand from it and what you didn't understand?


Regards,
Dariyoosh
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590476 is a reply to message #590473] Thu, 18 July 2013 07:36 Go to previous messageGo to next message
pablolee
Messages: 2590
Registered: May 2007
Location: Scotland
Senior Member
JEETUORAFAQ wrote on Thu, 18 July 2013 13:11
Thank you both for replies but The examples given there are not enough to understand the whole concept.
if possible then give your own example with expanation , dont copy from somewhere
Thanks

I smell a homework assignment, someone looking to plagiarise without plagiarising.
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590487 is a reply to message #590476] Thu, 18 July 2013 09:57 Go to previous messageGo to next message
JEETUORAFAQ
Messages: 4
Registered: July 2013
Location: India
Junior Member
Read it again what i have asked "Someone make me understand the concept of Exists, With and Correlated Subquery in Sql plus 10g from begining, what are they how do they work with step by step example from basic"
n if you cant do this then dont reply please.
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590489 is a reply to message #590487] Thu, 18 July 2013 10:05 Go to previous messageGo to next message
pablolee
Messages: 2590
Registered: May 2007
Location: Scotland
Senior Member
Nice attitude. Good luck.
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590490 is a reply to message #590487] Thu, 18 July 2013 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
If you are ever dissatisfied with the tone, tenor, completeness, correctness, or timeliness of any response,
please submit your request for a prompt & full refund to /dev/null


With free advice, sometimes you get what you paid for it!
Re: Need Help in Advance Subqueries (Exists,With .Correlated Subquery) [message #590492 is a reply to message #590490] Thu, 18 July 2013 10:57 Go to previous message
d_seng
Messages: 50
Registered: November 2011
Location: UK
Member
BlackSwan wrote on Thu, 18 July 2013 16:06
please submit your request for a prompt & full refund to /dev/null
Laughing
Previous Topic: Update SQL
Next Topic: know the execution time without running the query
Goto Forum:
  


Current Time: Wed Apr 16 21:43:20 CDT 2014

Total time taken to generate the page: 0.12631 seconds