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

What are temporal data types in oracle?

598


Does oracle partitioning improve performance?

552


How to call a stored function in oracle?

574


How to define a sub function?

668


What is meant by raw datatype?

572






is there a tool to trace queries, like profiler for sql server?

608


What are the differences between primary key and unique key?

515


How to use select statement to count the number of rows in oracle?

557


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1666


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2067


what is the scripts in data base?

1603


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021


What is max rowid in oracle?

559


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1442


Can group functions be mixed with non-group selection fields?

536