Home » SQL & PL/SQL » SQL & PL/SQL » Sub Queries (Oracle 9i)
Sub Queries [message #395662] Thu, 02 April 2009 03:14 Go to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
Sub Queries:

How many sub queries can be used in one query? OR
Is there any limitations for subquery to be used in a Query
Re: Sub Queries [message #395665 is a reply to message #395662] Thu, 02 April 2009 03:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Depends on the oracle version, but

here's a link to the 9i documentation to get you started. Why do you want to know?

MHE
Re: Sub Queries [message #396470 is a reply to message #395665] Mon, 06 April 2009 20:24 Go to previous messageGo to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
I am not satisfied with your answer.

I wanted to know how many subqueries minimum can be embedded in one query?
Re: Sub Queries [message #396472 is a reply to message #395662] Mon, 06 April 2009 20:34 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I wanted to know how many subqueries minimum can be embedded in one query?
a minimum of ZERO subqueries can be embedded in one query?
Re: Sub Queries [message #396500 is a reply to message #396470] Tue, 07 April 2009 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sharmakranthi wrote on Tue, 07 April 2009 03:24
I am not satisfied with your answer.

I am not satisfied with your answer.
Did you read SQL Reference?

Regards
Michel

Re: Sub Queries [message #401164 is a reply to message #396472] Fri, 01 May 2009 20:41 Go to previous messageGo to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
>I wanted to know how many maximum subqueries can be embedded in one query?
a minimum of ZERO subqueries can be embedded in one query?
Re: Sub Queries [message #401165 is a reply to message #395662] Fri, 01 May 2009 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Your answer is just a few clicks beyond the URL below.
http://tahiti.oracle.com
Let us know when you have found your answer.
Re: Sub Queries [message #401219 is a reply to message #401164] Sat, 02 May 2009 14:18 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sharmakranthi wrote on Sat, 02 May 2009 03:41
>I wanted to know how many maximum subqueries can be embedded in one query?
a minimum of ZERO subqueries can be embedded in one query?

So, during the last month you have concluded that there may be minimum of 0 (zero, none) subqueries embedded in one query. So far, so good.

Now you'd want to find MAXIMUM number of subqueries. As you've said that you use Oracle 9i, and regarding the fact that Maarten provided a link which in exactly two clicks reveals the answer, I can't think of any valid reason for you saying
sharmakranthi, answering Maarten's reply
I am not satisfied with your answer.
Shame on you!
Re: Sub Queries [message #401231 is a reply to message #401219] Sun, 03 May 2009 00:10 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
./fa/3400/0/
Re: Sub Queries [message #401232 is a reply to message #401231] Sun, 03 May 2009 00:13 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
touche'

joicejohn wrote on Sat, 02 May 2009 22:10
./fa/3400/0/



Alternatively just "ignore all messages by this user"
Previous Topic: SQL,PLSQL mutiple order by with decode issue
Next Topic: Stored Procedure using dbms_random.value
Goto Forum:
  


Current Time: Sun Dec 04 00:38:26 CST 2016

Total time taken to generate the page: 0.13397 seconds