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 difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1071


What is the maximum number of rows in sql table?

1030


What is scope and visibility in PL/SQL?

1205


What is rownum?

985


What are aggregate functions in sql?

1166


What is difference between procedure and trigger?

984


What is pragma in sql?

1084


Explain lock escalation? : Transact sql

1203


What is the order of sql select?

1041


How run sql*plus commands that are stored in a local file?

1061


What are the different types of joins in sql?

1796


Does postgresql run on the cloud?

1152


Difference between table function and pipelined function?

1028


Why is sql important?

1112


What are the two virtual tables available at the time of database trigger execution?

1222