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 / roshan

ONE THING I WOULD LIKE TO TELL.. SUBQUERY RUNS MUCH FASTER
THAN CO-RELATED QUERY..
BECAUSE EACH TIME IT HAS TO COMPARE THE OUTER QUERY IS
EVALUATED EACH TIME............

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between varchar and varchar2 data types?

1172


Explain oracle’s server parameter file.

981


Explain an integrity constrains?

1135


Can you assign multiple query result rows to a variable?

981


How to start a specific oracle instance?

1029


How to create a stored function in oracle?

1099


what are steps for interface? where is exchange rate defined in which table?

2144


How to invoke the data pump import utility?

1156


What are the logical operations?

1114


What are the types of partitions in oracle?

1032


How to write date and time interval literals in oracle?

1025


What is oracle latest version?

1090


How to build data dictionary view an new database?

998


What is a nested table and how is it different from a normal table?

1044


What is the relation of a user account and a schema in oracle?

1078