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
How to create a new oracle data file?
What is a user role in oracle?
What is an Oracle index?
State some uses of redo log files?
What is the usage of synonyms?
How to create a new user account in oracle?
What is a schema in oracle?
What is index in Oracle?
What is the difference between truncate & delete command?
Is primary key indexed by default in oracle?
How to view all columns in an existing table?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is difference between truncate and delete?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?