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...

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

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

Will you be able to store pictures in the database?explain.

988


How to create a table index?

1136


How to divide query output into groups in oracle?

981


Explain the truncate in oracle?

959


What is connection pooling in oracle?

962


What is oracle instant client?

1019


What is an Oracle index?

1646


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1977


Explain overloading. Can functions be overloaded?

974


How do I use os authentication with weblogic jdriver for oracle and connection pools?

1040


What is the usage of control file in oracle?

1076


definition of cluster and non-clustered index?

3021


How can we view last record added to a table?

1033


What is rowid and rownum in oracle?

1005


How to assign a table row to a record variable?

1027