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

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is tns service name?

721


Is oracle the best database?

609


How to speed up webrick?

700


types of indexes and the rationale behind choosing a particular index for a situation.

2105


What are oracle functions?

654






How to use null as conditions in oracle?

663


Is oracle a relational database?

603


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1678


Can we write insert statement in function in oracle?

650


How to define an external table with a text file?

676


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1028


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1726


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1813


Which is faster join or subquery in oracle?

622


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1356