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 is the order of sql select?

1088


Explain clause in sql?

1071


How would you reference column values before and after you have inserted and deleted triggers?

1117


what is view? : Sql dba

1029


explain the advantages and disadvantages of stored procedure? : Sql dba

1061


What is the difference between sql and t sql?

1106


How to use sql statements in pl/sql?

1189


How many types of relationship are there?

1082


What is dcl in sql?

1024


Explain alias in sql?

1094


What is linq to sql?

1178


What programs use sql?

1086


What is a stored procedure in sql with example?

1200


How can you load microsoft excel data into oracle? : aql loader

1213


what is oracle database ? : Sql dba

1078