what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 18389 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
What are triggers in oracle?
What is Undo Management Advisor in Oracle?
How to rebuild an index in oracle?
Explain oracle 12c new features for developers?
What are the system predefined user roles?
What are the different types of partitions in oracle?
How to increment dates by 1 in oracle?
What are the arithmetic operations?
How to return top 5 rows in oracle?
What is a relational database management system?
How to define an anonymous block?
Can you assign multiple query result rows to a variable?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How do you find current date and time in oracle?
Can we store pictures in the database and if so, how it can be done?
