what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 17402 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
Compare and contrast between sql and sql server and explain its various functions?
interview questions with answer for cts
What is catalog in Oracle?
What is an Oracle index?
What is a read only transaction in oracle?
what is the scenario where you take the database to NoArchivelog mode?
How to shutdown your 10g xe server?
How to use an explicit cursor without open statements?
What is primefaces used for?
State the various uses of dbcc command?
What is format trigger?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Explain the difference between sap and oracle?
How to convert csv to table in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
