Answer / 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.

Answer / jyoti

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

Answer / pandarinath

joins project the data from more than one table vertically
based on common cloumns among the tables.
in case of set operators, its combine(merge) data horizantally, programer have to manage the correct logic and sence in the data. set operators uses for data presentation.

Answer / mahesh

suppose if we have joined two tables display the both table column names whatever we are giving and incase if we are use set operators columns not displyaed both tables.only first select query columns only displayed.

Answer / nitin

There is no such difference between JOINS and SET operators. You can get the same result by using JOIN or SET operator.

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1 Answers  

---

How to select some rows from a table in oracle?

1 Answers  

---

What is index-organized table in Oracle?

1 Answers   MCN Solutions,

---

What is the Tune Query

1 Answers  

---

How many data types are supported?

1 Answers  

---

What is schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,

---

How to use like conditions in oracle?

1 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

What is a package in oracle?

1 Answers  

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

What is a nested table?

1 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---