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
Explain the use of grant option in exp command.
Why does Oracle not permit the use of PCTUSED with indexes?
What are the tools for Oracle ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the dml?
Explain what are synonyms used for?
Explain index?
Why does for update in oracle 8 cause an ora-01002 error?
What are the differences between primary key and unique key?
How view is different from a table?
Is there a combination of "like" and "in" in sql?
What is the difference between a hot backup and a cold backup in oracle?
What is recovery manager in Oracle?
Why is oracle used?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??