what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 17349 Views
- HCL, LN, I also Faced
- E-Mail Answers
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
How can we find out the duplicate values in an oracle table?
What is recovery manager in Oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What is a tns service name?
State some uses of redo log files?
Please explain joins in oracle?
What are the predefined tablespaces in a database?
What is the difference between substr & instr functions?
How to declare a local variable?
How will you write a query to get a 5th rank student from a table student_report?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
what is meant by magic query
WHAT IS ecc 6.0
what are steps for interface? where is exchange rate defined in which table?
How to use windows user to connect to the server?
