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

Answer Posted / nitin

There is no such difference between JOINS and SET operators. You can get the same result by using JOIN or SET operator.

Is This Answer Correct ?    2 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1584


How to define an anonymous procedure with variables?

742


What is recovery manager(rman) backup in Oracle?

850


How many types of tables supported by oracle?

774


What is an oracle user account?

744


How to load data from external tables to regular tables?

786


What is tns entry?

801


What happens to the current transaction if the session is ended?

778


How to assign query results to variables?

784


What is dynamic proxy?

748


what are steps for interface? where is exchange rate defined in which table?

1718


How to rename an index?

784


How to connect the oracle server as sysdba?

810


Can we commit inside a function in oracle?

713


Why oracle is used?

778