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
In the oracle version 9.3.0.5.0, what does each number shows?
what are archived logs?
How to count duplicated values in a column in oracle?
What is a relational database management system?
What is a nvl function? How can it be used?
How to use "out" parameter properly?
How to connect ms access to oracle servers?
What are the ansi data types supported in oracle?
How to estimate disk space needed for an export job?
List the types of joins used in writing subqueries?
What are the arithmetic operations?
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.
Hi Can any one tell me what are the API's used in requisition import.
What is an anonymous block?
How to define default values for formal parameters?