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 .
- 5 Answers
- 19554 Views
- HCL, LN, I also Faced
- E-Mail Answers
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
How can I introduce multiple conditions in like operator?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a table index?
Which is faster join or subquery in oracle?
What is an oracle database table?
master table and child table performances and comparisons in Oracle ?
What is the relation of a user account and a schema in oracle?
What is a cursor variable?
Can we call procedure inside function in oracle?
What happens to the current transaction if the session is ended?
What suggestions do you have to reduce the network traffic?
Is primary key indexed by default in oracle?
how may join possible between (requisition with purchase order)
Does oracle partitioning improve performance?
How to rename a column in an existing table?
