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
- 19713 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 is the difference between a hot backup and a cold backup in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain what are the different type of segments?
What is a nested table?
What is difference between cartesian join and cross join?
How to create a new view in oracle?
What is not equal to in oracle?
How to work with data objects interactively?
How to rename a tablespace in oracle?
How to retrieve data from an explicit cursor?
What is a server parameter file in oracle?
How to use an explicit cursor without open statements?
Where do you use decode and case statements?
How to delete a user account in oracle?
How to drop an existing table in oracle?
