Interested to Buy Any Domain ? << Click Here >> for more details...
How many levels can subqueries be nested in a FROM clause?
- 7 Answers
- 25945 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
Explain the components of sql?
What is an exception in pl/sql?
What is the largest value that can be stored in a byte data field?
Can we insert data into materialized view?
What is trigger price?
Why are cursors used?
How to revise and re-run the last sql command?
How do you truncate?
Can we use loop in sql?
how to write date and time literals? : Sql dba
tell me about various levels of constraint. : Sql dba
What is pivot query?
What is the requirement of self-join?
What is difference between rank () row_number () and dense_rank () in sql?
What are data types in pl sql?
