what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
Answer Posted / amretha
For set operators the columns in the tables must be the same.Where as for Joins if one column is same its enough to join two or more tables.
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
What is the difference between translate and replace?
How do I know if oracle client is installed on windows?
how to handle exceptions in post production
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to add a new column to an existing table in oracle?
What is the fastest query method to fetch data from the table?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is materialized view in Oracle?
What is rich query?
query optmization techniques and quwry analyser+projects+ppts
Explain the use of online redo log files in oracle.
how to make an oracle object
What are the uses of Database Trigger ?
What is Redo Log Buffer in Oracle?
if you ctreate table identity