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.

What are the differences between primary key and unique key?

0 Answers  

Explain the use of full option in exp command.

0 Answers  

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

How to use existing values in update statements using oracle?

0 Answers  

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

How to test null values?

0 Answers  

Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  

Explain what are the different type of segments?

0 Answers  

How to declare a local variable?

0 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

what is the use of rank function?

1 Answers  

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers