There is no limit on the no.of sub queries in the FROM clause. in WHERE

How many levels can subqueries be nested in a FROM clause?

Question Posted / sulochana

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

Please Help Members By Posting Answers For Below Questions

What is data type in database?

1003

How do you know if a relationship is 2nf?

955

Are subqueries faster than joins?

1027

Explain what is sql*plus?

1152

How does one use sql*loader to load images, sound clips and documents? : aql loader

1194

Can one improve the performance of sql*loader? : aql loader

1055

What is bind reference and how can it be created?

1026

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2580

What is a mutating table and a constraining table?

1122

What is a unique key and primary key and foreign key?

972

How many columns should be in an index?

967

What is query execution plan in sql?

1194

Can we use rowid as primary key?

995

What is implicit cursor in pl sql?

1099

Can we join 3 tables in sql?

1053