what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
- 5 Answers
- 17928 Views
- HCL, LN, I also Faced
- E-Mail Answers
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
What is tns service name?
Is oracle the best database?
How to speed up webrick?
types of indexes and the rationale behind choosing a particular index for a situation.
What are oracle functions?
How to use null as conditions in oracle?
Is oracle a relational database?
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
Can we write insert statement in function in oracle?
How to define an external table with a text file?
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?
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.
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
Which is faster join or subquery in oracle?
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??
