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

Difference between sub query and nested query ?

Answer Posted / s.maheshbabu

quarry inside a quarry is called sub quarry.when sub quarry
is also called nested quarry.
co-related sub quarry is one as inner quarry is evaluated.is
anther result of inner are evaluated.
nested quarry is multiple time of one outer quarry.

ex;-quarry used in()caused co-related quarry.
quarry used with=operator is nested quarry.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a table in a specific tablespace?

968


What are nested tables?

1158


Explain enable novalidate constraint.

1071


What is an Oracle index?

1645


Can you drop an index associated with a unique or primary key constraint?

1011


What is a select query statement in oracle?

955


Explain the use of owner option in exp command.

1037


What is oracle data type?

954


What is meant by joins? List out the types of joins.

1019


How to define default values for formal parameters?

1033


What is Segment Advisor in Oracle?

1099


What is the order of defining local variables and sub procedures/functions?

1051


What are the limitations oracle database 10g xe?

1037


How to count groups returned with the group by clause in oracle?

1063


Can objects of the same schema reside in different tablespace?

1058