Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 19555 Views
- HCL, LN, I also Faced
- E-Mail Answers
Answer Posted / mahesh
suppose if we have joined two tables display the both table column names whatever we are giving and incase if we are use set operators columns not displyaed both tables.only first select query columns only displayed.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to drop an existing view in oracle?
What is an external table?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
what is the difference between data migration and production migration.
What do you mean by merge in oracle and how can you merge two tables?
What is a nvl function? How can it be used?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain parameter file in oracle.
What is logical backup in oracle?
What is a static data dictionary in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Why should I use oracle database?
Which is faster join or subquery in oracle?
What is connection pool in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
