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 Library Cache in Oracle?
What is a lookup table in oracle?
What do you mean by merge in oracle and how can we merge two tables?
How can I get column names from a table in oracle?
What is tns name?
What are the built-in functions used for sending Parameters to forms ?
What are the uses of a database trigger?
What is partitioned table in Oracle?
What is redo log?
State some uses of redo log files?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is the difference between "as" and "is" in an oracle stored procedure?
What are the most common interview questions on ETL Testing for experience?
Why do we need oracle client?
What is integrity and what is constraint??Explain with example