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
- 19297 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
What happens to indexes if you drop a table?
How to create a single index for multiple columns?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How would you begin to troubleshoot an ORA-3113 error?
What is an oracle user account?
How to list all user accounts in oracle?
What is format trigger?
How to create a testing table in oracle?
What is execute immediate in oracle?
How to start a new transaction in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How index is implemented in oracle database?
What is a sub query? Describe its types?
Explain what are the uses of rollback segment?
ABOUT IDENTITY?
