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

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

Name the operator which is used in the query for pattern matching?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

what is a foreign key ? : Sql dba

0 Answers  

Is subquery faster than join?

0 Answers  

how can we find the select statement is indexed or not?

3 Answers   CTS,

What is procedure in pl sql?

0 Answers  

Is left join same as join?

0 Answers  

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

what does the t-sql command ident_current does? : Transact sql

0 Answers  

What is function and procedure in pl sql?

0 Answers  

What is column?

0 Answers