Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / pradeep

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


Please Help Members By Posting Answers For Below Questions

How do I audit the sql sent to the server?

992

What is keys and its types?

1059

Are views faster than queries?

976

Is there any restriction on the use of union in embedded sql?

1147

What is the difference between clustered and non-clustered indexes?

1073

Can we use commit inside a trigger?

1071

Which table is left in left join?

992

What is execute immediate?

1067

Explain commit, rollback and savepoint.

981

What is int identity in sql?

1114

Is sql workbench free?

971

How can you select unique records from a table?

1053

Why do we create views in sql?

1129

What are the different tcl commands in sql?

1151

what is row? : Sql dba

1205