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

Answer Posted / bhuvana

Joins-
1.Want to combine and fetch data from more than 2 tables.
2.Joins are faster, efficient, easy to understand and better performance.
Subquery-
Want to combine and fetch data from a pair of table.

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many categories of data types in oracle?

952

Can you create a synonym without having a table?

976

How to use regular expression in pattern match conditions in oracle?

973

What is tns service name?

1068

What is integrity and what is constraint??Explain with example

2213

How to convert csv to table in oracle?

920

How much memory your 10g xe server is using?

1046

What are the attributes that are found in a cursor?

1010

what are the advantages of running a database in archive log mode?

2139

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2257

When do we use group by clause in a sql query?

990

WHAT IS ecc 6.0

2094

What is the difference between substr and instr?

974

What is oracle used for?

966

How to use "in" parameter properly?

999