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

How to use "startup" command to start default instance?

536


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

542


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1731


What are the different windows events activated at runtime ?

2403


Point out the difference between user tables and data dictionary?

535






How do I call oracle stored procedures that take no parameters?

558


Explain the function of optimizer in oracle?

587


How to grant create session privilege to a user in oracle?

560


Can select statements be used on views in oracle?

586


What do you mean by redo log file mirroring?

549


Explain database link?

651


How do you find current date and time in oracle?

578


What is transport network substrate (tns) in oracle?

583


How to write date and time literals in oracle?

547


How to use "while" statements in oracle?

729