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?
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 |
what is the use of system.effective.date variable in oracle?
What is the difference between a vector and an Array? (Java)
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Explain what are clusters?
Will you be able to store pictures in the database?
Why do we need oracle client?
How to update values on multiple rows in oracle?
Why we choose emp number as primarykey?
How to create a new view in oracle?
what r tyhe major differences between oracle 9i & 10g?
how to join query for one source type is oracle another source type is sql server ?
What is open database communication (odbc) in oracle?