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 order of sql select?
Explain clause in sql?
How would you reference column values before and after you have inserted and deleted triggers?
what is view? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
What is the difference between sql and t sql?
How to use sql statements in pl/sql?
How many types of relationship are there?
What is dcl in sql?
Explain alias in sql?
What is linq to sql?
What programs use sql?
What is a stored procedure in sql with example?
How can you load microsoft excel data into oracle? : aql loader
what is oracle database ? : Sql dba