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 types of exception?
How to use "if" statements on multiple conditions?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is program global area (pga) in oracle?
How to connect ms access to oracle servers?
What language does oracle use?
What is an Oracle index?
How do I limit the number of oracle database connections generated by weblogic server?
What is connection pool in oracle?
What is the difference between $oracle_base and $oracle_home?
How do you find current date and time in oracle?
Give the various rollback segment states.
How are extents allocated to a segment?
How does the on-delete-cascade statement work?
How to retrieve data from an cursor to a record?