what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
Answer Posted / amretha
For set operators the columns in the tables must be the same.Where as for Joins if one column is same its enough to join two or more tables.
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
Explain the use of record option in exp command.
How do I manually create a database in oracle?
How to use "in out" parameter properly?
What is a tns file?
What is the scope of a local variable?
What is memory advisor in Oracle?
How to see the table columns used in an index?
How to export your connection information to a file?
How to select an oracle system id (sid)?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is bulk collect in oracle?
Why use resource manager in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
How do I spool in oracle?
What is snapshot is too old? Give and example for better understand.