How many levels can subqueries be nested in a FROM clause?
Answer Posted / 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 |
Post New Answer View All Answers
How do sql databases work?
How do I count rows in sql?
Can we call procedure in select statement?
What are sql*plus environment variables?
What is the current version of postgresql?
How do I run sql profiler?
what are the properties and different types of sub-queries? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are types of joins?
How subquery works in sql?
How long will it take to learn pl sql?
Which is faster subquery or join?
What is normalization sql?
What's the difference between inner join and left join?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?