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 sql does db2 use?
what is meant by nl2br()? : Sql dba
What is a null value?
What is difference between mysql and postgresql?
Can a varchar be a primary key?
Explain the uses of control file.
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Which are the different case manipulation functions in sql?
Is primary key clustered index?
What is difference between cursor and trigger?
What does select top 1 do in sql?
Why do you partition data?
What is coalesce in sql?
Can we use join in subquery?
Why is sql*loader direct path so fast?