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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2088


How to define a variable to match a table column data type?

753


What is logical backup in oracle?

770


Can a formula column be obtained through a select statement ?

2089


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

746


How to create a single index for multiple columns?

758


Explain what are clusters?

835


Why use resource manager in Oracle?

865


what are bitmap indexes? How does they work?

1958


What the is the diff between local index and global index. give some example.

1368


What are the restrictions in a oracle read only transaction?

760


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1984


What are the different types of database objects?

727


State some uses of redo log files?

757


Can group functions be used in the order by clause in oracle?

764