How many levels can subqueries be nested in a FROM clause?
Answer Posted / sulochana
There is no limit on the no.of sub queries in the FROM clause.
in WHERE clause ,we can write upto 255 levels only..
Thanks & Regards,
Sulochana
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Why do we use procedures in pl sql?
Why do we use %rowtype & %type in plsql?
what is sp_pkeys? : Transact sql
What are the 3 types of behavioral triggers?
what is the difference between char and varchar data types? : Sql dba
What is string data type in sql?
what is a database transaction? : Sql dba
what are sequences
How to connect a sql*plus session to an oracle server?
What are triggers and its types?
What is sql comments?
How do you rename a table in sql?
what is the difference between $message and $$message? : Sql dba
What is rtm stands for?