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
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is the maximum number of rows in sql table?
What is scope and visibility in PL/SQL?
What is rownum?
What are aggregate functions in sql?
What is difference between procedure and trigger?
What is pragma in sql?
Explain lock escalation? : Transact sql
What is the order of sql select?
How run sql*plus commands that are stored in a local file?
What are the different types of joins in sql?
Does postgresql run on the cloud?
Difference between table function and pipelined function?
Why is sql important?
What are the two virtual tables available at the time of database trigger execution?