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 join and a subquery?

Question Posted / katty

Answer Posted / katty

When data is to be retrieved from one table based on the condition from another table subquery is used 
When the data is to be retrieved from both the tables join is used

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by merge in oracle and how can you merge two tables?

1001

Explain an index segment?

1155

State all possible different index configurations a table can possibly have?

1095

What is oracle used for?

1067

Is oracle the best database?

1006

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

1111

Differentiate between translate and replace?

1184

How remove data files before opening a database?

1131

What is a trigger oracle?

1134

Is insert autocommit in oracle?

1128

What is difference between sid and service name in oracle?

1006

What are the data types in oracle?

1095

How to generate query output in html format?

1203

What privilege is needed for a user to insert rows to tables in another schema?

1056

Explain the difference between replace() and translate() functions in oracle?

1082