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.

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

0 Answers  

How you find out version of installed workflow?

1 Answers  

What is difference between cartesian join and cross join?

0 Answers  

What is a tns file?

0 Answers  

Explain user account with reference to oracle.

0 Answers  

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,

What is the difference between a primary key & a unique key?

0 Answers  

What is a Private Synonyms ?

1 Answers  

How to work with data objects interactively?

0 Answers  

Which is faster join or subquery in oracle?

0 Answers  

List out the difference between commit, rollback, and savepoint?

0 Answers