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

In the oracle version 9.3.0.5.0, what does each number shows?

1301


what are archived logs?

2199


How to count duplicated values in a column in oracle?

1039


What is a relational database management system?

1120


What is a nvl function? How can it be used?

1031


How to use "out" parameter properly?

1082


How to connect ms access to oracle servers?

1006


What are the ansi data types supported in oracle?

947


How to estimate disk space needed for an export job?

1050


List the types of joins used in writing subqueries?

996


What are the arithmetic operations?

1084


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2183


Hi Can any one tell me what are the API's used in requisition import.

1923


What is an anonymous block?

1249


How to define default values for formal parameters?

1044