Answer / vikas trivedi

32 levels of nesting within a query is possible.

Answer / ravi

255 levels

Answer / pradeep

http://download.oracle.com/docs/cd/B19306_01/server.102/b142
00/queries007.htm

The below stated on above page from oracle

A subquery can contain another subquery. Oracle Database
imposes no limit on the number of subquery levels in the
FROM clause of the top-level query. You can nest up to 255
levels of subqueries in the WHERE clause.

Answer / slokh

FROM clause
A subquery can also be found in the FROM clause. These are
called inline views.

For example:

select suppliers.name, subquery1.total_amt
from suppliers,
(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1,
where subquery1.supplier_id = suppliers.supplier_id;

In this example, we've created a subquery in the FROM
clause as follows:

(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1

This subquery has been aliased with the name subquery1.
This will be the name used to reference this subquery or
any of its fields.

Limitations:

Oracle allows an unlimited number of subqueries in the FROM
clause.

Answer / shekaran04

Oracle imposes no limit on the number of SUB Queries levels
in the from clause

Answer / sulochana

There is no limit on the no.of sub queries in the FROM clause.

in WHERE clause ,we can write upto 255 levels only..





Thanks & Regards,
Sulochana

Answer / john

32 number of Subquery

http://msdn.microsoft.com/en-us/library/ms143432.aspx

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

What is sql*plus?

0 Answers  

what is a relationship and what are they? : Sql dba

0 Answers  

Is pl sql still used?

0 Answers  

What is cursor in pl sql with examples?

0 Answers  

How do I kill a query in postgresql?

0 Answers  

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

will function return more than one value how

9 Answers   Accenture,