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
Why we use bulk collect in oracle?
How to write a query with an inner join in oracle?
How to use null as conditions in oracle?
What is partitioned table in Oracle?
What is the maximum limit on the number of columns in a table?
Explain the dml?
please explain.. DB architecture ...
1) Does oracle have any table which contain all the exceptions and it's code internally?
ABOUT IDENTITY?
How does oracle handle read consistency?
What is clustered table in Oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
candidate key is subset of super key but not vice-verse explain
Can we insert data in view oracle?
What do you mean by merge in oracle?