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 use an oracle sequence generator in a mapping?
Explain the difference between replace() and translate() functions in oracle?
Briefly explain what is literal? Give an example where it can be used?
What are the attributes of cursor?
How to create a new table in your schema?
How to open a cursor variable?
Can you assign multiple query result rows to a variable?
How to convert numbers to characters in oracle?
What do you mean by group by clause?
What are the limitations of check constraint?
How to create tables for odbc connection testing?
How to write text literals in oracle?
What types of joins are used in writing subqueries?
Which is better Oracle or MS SQL? Why?
What is set verify off in oracle?