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 / mohammed al-fahed

Answer Posted / mohammed al-fahed

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, which resinde in the WHERE
clause.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to specify default values in insert statement using oracle?

1097

What are the attributes of cursor?

1044

What are ddl statements in oracle?

1072

How to get a list of all background sessions in the database?

988

What is a nested table?

1051

Explain oracle left join with an example?

1003

How to define a procedure inside another procedure?

1009

query optmization techniques and quwry analyser+projects+ppts

2410

What is a read write transaction in oracle?

1081

How can we find out the current date and time in oracle?

1086

How to delete all rows a table in oracle?

1065

How to loop through a cursor variable?

1080

Design database draw er diagram for a certain scenario ?

4575

How do I know if oracle client is installed on windows?

1017

Explain parameter file in oracle.

1020