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

How to use "startup" command to start default instance?

980


What is an oracle database table?

968


what is the scripts in data base?

2094


What happens in oracle commit?

977


What exactly do quotation marks around the table name do?

926


What are the uses of synonyms?

1097


What is the data pump import utility?

988


How to create lov dynamically at runtime & attach to text field?

1117


What is query image?

934


How to use select statement to count the number of rows in oracle?

1004


What are ddl statements in oracle?

1027


Explain the dml?

928


how to do daily transactions with out sql* loader control file regesterd in apps?

1648


How to create a testing table in oracle?

954


What is SQL Tuning Advisor in Oracle?

1121