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

what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .

Question Posted / pandarinath

Answer Posted / pandarinath

joins project the data from more than one table vertically
based on common cloumns among the tables.
in case of set operators, its combine(merge) data horizantally, programer have to manage the correct logic and sence in the data. set operators uses for data presentation.

Is This Answer Correct ?    5 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle thin client?

970

How can I see all tables in oracle?

949

List the types of joins used in writing subqueries?

938

Explain a synonym?

969

How a database is related to tablespaces?

980

What are the types of partitions in oracle?

973

How many data types are supported?

1017

What is a snapshot log?

948

How do we represent comments in oracle?

999

Can a formula column referred to columns in higher group ?

2455

What is the difference between a primary key & a unique key?

1036

How to create a new user account in oracle?

952

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2304

How to test null values?

1039

What is the usage of merge statement?

1094