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

Answer Posted / nirvaya

A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the dml?

928

What is an oracle user account?

939

How to start instance with a minimal initialization parameter file?

994

How to synchronize 2 schema's objects?

2123

What is materialized view in Oracle?

1046

How do I learn what codesets are available in oracle?

1007

What language does oracle use?

1056

How many categories of data types in oracle?

969

How to use an explicit cursor without open statements?

1017

Explain an integrity constrains?

1090

Explain the use of record length option in exp command.

1031

List the types of joins used in writing subqueries?

951

What is the use of oracle?

990

Explain the use of grant option in imp command.

965

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1013