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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Difference between sub query and nested query ?

Question Posted / roopesh kumar

Answer Posted / roopesh kumar

Main Diff. b/w Subquery & Nested Subquery:

The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery.

Is This Answer Correct ?    25 Yes 36 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Redo Log Buffer in Oracle?

1198

Difference between varchar and varchar2 data types?

1176

What is tns entry?

1129

How to retrieve data from an cursor to a record?

1095

Describe varray?

1052

How to export your own schema?

1007

What are the differences between char and nchar in oracle?

1081

How many types of tables are there in oracle?

1052

How would you go about verifying the network name that the local_listener is currently using?

2042

how to clone 9i Database on to 10g Database.

2331

How to create an initialization parameter file?

1037

State some uses of redo log files?

994

does the query needs a hint to access a materialized view?

1854

Explain what does a control file contain?

1092

What is an oracle data file?

1097