what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 18382 Views
- HCL, LN, I also Faced
- E-Mail Answers
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
What are the logical operations?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain coalesce function?
what is the use of system.effective.date variable in oracle?
What is the difference between sharding and partitioning?
Explain an integrity constrains?
Can we write dml statement in function in oracle?
Explain the use of rows option in exp command.
Can a formula column be obtained through a select statement ?
What are the advantages of oracle?
How to initialize variables with default values?
Why do we use bulk collect in oracle?
How do I find my oracle client driver version?
What happens to the data files if a tablespace is dropped?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
