what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
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 is a cursor variable?
What is the scope of a local variable?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is query image?
What is the difference between primary key and unique key and foreign key in oracle?
What is the difference between post-database commit and post-form commit?
What are the different types of partitions in oracle?
6. Display the client name and order date for all orders using the traditional method.
What is merge statement used for?
How to delete an existing row from a table in oracle?
what is the difference between restoring and recovering?
What is an oracle?
What are the restrictions on external table columns?
List out the components of logical database structure of oracle database.
How to manage transaction isolation level?