Home » SQL & PL/SQL » SQL & PL/SQL » Correlated subquery
Correlated subquery [message #319154] Fri, 09 May 2008 03:32 Go to next message
shanthakumar.utt
Messages: 15
Registered: May 2008
Location: bangalore
Junior Member
Hi all,

co related subquery is 1:1 or 1:n or n:1

thanks in advance

[MERGED by LF]

[Updated on: Fri, 09 May 2008 05:04] by Moderator

Report message to a moderator

Re: co relted query [message #319156 is a reply to message #319154] Fri, 09 May 2008 03:35 Go to previous messageGo to next message
kecd_deepak
Messages: 52
Registered: December 2007
Member
Hi,
The answer as i understand from your problem is

1:n

for each record from outer queery compare with each record of inner querry.
views and corelated subquery [message #319160 is a reply to message #319154] Fri, 09 May 2008 04:18 Go to previous messageGo to next message
shanthakumar.utt
Messages: 15
Registered: May 2008
Location: bangalore
Junior Member
Hi all,

In under which scenario view and corelated subquery used please help with simple example?

thx in advance
Re: co relted query [message #319164 is a reply to message #319154] Fri, 09 May 2008 04:22 Go to previous messageGo to next message
shanthakumar.utt
Messages: 15
Registered: May 2008
Location: bangalore
Junior Member
hi thanks for the reply and let me know simple example on that 1:n

thanks in advance
Re: co relted query [message #319185 is a reply to message #319164] Fri, 09 May 2008 05:04 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/search?remark=quick_search&word=correlated+subquery&tab_id=&format=ranked

Regards
Michel
Previous Topic: implicit cursor
Next Topic: Read images from Long Raw datatype column in table
Goto Forum:
  


Current Time: Tue Feb 11 09:57:42 CST 2025