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 use "startup" command to start default instance?
What is an oracle database table?
what is the scripts in data base?
What happens in oracle commit?
What exactly do quotation marks around the table name do?
What are the uses of synonyms?
What is the data pump import utility?
How to create lov dynamically at runtime & attach to text field?
What is query image?
How to use select statement to count the number of rows in oracle?
What are ddl statements in oracle?
Explain the dml?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to create a testing table in oracle?
What is SQL Tuning Advisor in Oracle?