How many levels can subqueries be nested in a FROM clause?
Answers were Sorted based on User's Feedback
Answer / vikas trivedi
32 levels of nesting within a query is possible.
Is This Answer Correct ? | 36 Yes | 12 No |
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.
Is This Answer Correct ? | 8 Yes | 1 No |
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.
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / shekaran04
Oracle imposes no limit on the number of SUB Queries levels
in the from clause
Is This Answer Correct ? | 5 Yes | 3 No |
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
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / john
32 number of Subquery
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Is This Answer Correct ? | 3 Yes | 3 No |
explain access control lists. : Sql dba
Why we use join in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What is sql engine in oracle?
how to get enames with comma seperated values by deptwise on emp table?
What is the purpose of using pl/sql?
Is like operator in sql case sensitive?
Why select is used in sql?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
pl/sql testing means what ...... explain process how to find pl/sql bugs
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
What is pragma in pl sql?