Set - Comparison is to be performed on Tables. Join- Comparison is to per

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

Question Posted / jyoti

Answer Posted / jyoti

Set - Comparison is to be performed on Tables.
Join- Comparison is to performed on rows of tables.

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a package ? What are the advantages of package ?

1033

Explain implicit cursor.

957

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2305

Explain the use of parfile option in exp command.

985

Explain an exception and its types?

1008

What is a proxy class?

966

What is translate in oracle?

1042

types of indexes and the rationale behind choosing a particular index for a situation.

2443

What are the arithmetic operations?

1020

What are the execution control statements?

1014

How do I limit the number of rows returned by an oracle query after ordering?

1098

What are the uses of a database trigger?

920

What is user managed backup in Oracle?

1073

what is the scripts in data base?

2075

What is columnar storage what is the advantage?

985