Interested to Buy Any Domain ? << Click Here >> for more details...
I have table-A(1,2,3)& table-B(3,4,5).what is the different
b/w below questions?
A union all B?
B union all A?
- 2 Answers
- 5485 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anuradha
For the first case it will come : 1,2,3,3,4,5
For the second case it will come: 3,4,5,1,2,3
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / sudipta santra
For the first case it will come : 1,3,2,5,3,4
For the second case it will come: 5,3,4,1,3,2
No logic behind that .
| Is This Answer Correct ? | 3 Yes | 9 No |
How to drop a stored function?
What would you do if a database crashes in production?
Explain enable novalidate constraint.
How to load a large xml file?
What is a private synonym?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is execute immediate in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Can we create trigger on view in oracle?
What is Redo Log Buffer in Oracle?
what diffrence between function and procedure?
Oracle General 
