For set operators the columns in the tables must be the same.Where as for J

what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .

Question Posted / amretha

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

Please Help Members By Posting Answers For Below Questions

What is tns service name?

1120

Can we write insert statement in function in oracle?

1077

How many file formats are supported to export data?

1209

How to load data through external tables?

1132

What are the ansi data types supported in oracle?

942

how the indexes are stored in the Oracle Database?

2268

What is truncate oracle?

970

Difference between the “verify” and “feedback” command?

1358

What is clustered table in Oracle?

1182

State the difference between a primary key and foreign key?

930

is there a tool to trace queries, like profiler for sql server?

1138

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

966

What is a oracle database?

1051

What are advantages of dateset in datastage?

2257

How to test null values?

1096