How many levels can subqueries be nested in a FROM clause?
- 7 Answers
- 24590 Views
- I also Faced
- E-Mail Answers
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 mdf and ndf files?
How to handle bulk data?
What are some predefined exceptions in pl/sql?
Why is partition used in sql?
What is foreign key sql?
What is view? Can we update view
What is string data type in sql?
Why do we need sharding?
how to decrement dates by 1 in mysql? : Sql dba
What is the mutating table and constraining table?
Are stored procedures faster than dynamic sql?
What is the difference between union and union all command?
Why is nosql good?
Is primary key an index?
How do I run a script in sql developer?
