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
What is merge in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How can we find out the duplicate values in an oracle table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is the use of file param in imp command?
Explain a data segment?
What happens if you use a wrong connect identifier?
How do I limit the number of rows returned by an oracle query after ordering?
What is java oracle used for?
How to rename a tablespace in oracle?
How to change user password in oracle?
How to compare dates in oracle sql?
What are advantages of dateset in datastage?