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
How to put more than 1000 values into an oracle in clause?
How to use attributes of the implicit cursor in oracle?
How to fetch the row which has the max value for a column?
Explain compound trigger in oracle?
Give the advantages and disadvantages of clusters.
How to experiment a data lock in oracle?
How to count duplicated values in a column in oracle?
What is Data Dictionary Cache in Oracle?
How to lock and unlock a user account in oracle?
How to store only time; not date and time?
What is control file used for?
Explain a segment?
Write a syntax for update query in oracle?
Explain the use of grant option in imp command.
how can db_files > maxdatafiles since db_files is for instance and the later is for database