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...

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

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

What sql does db2 use?

926


what is meant by nl2br()? : Sql dba

974


What is a null value?

1085


What is difference between mysql and postgresql?

1043


Can a varchar be a primary key?

953


Explain the uses of control file.

991


what are the non-standard sql commands supported by 'mysql'? : Sql dba

1043


Which are the different case manipulation functions in sql?

953


Is primary key clustered index?

898


What is difference between cursor and trigger?

1017


What does select top 1 do in sql?

1001


Why do you partition data?

966


What is coalesce in sql?

971


Can we use join in subquery?

1022


Why is sql*loader direct path so fast?

1053