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 happens to the current transaction if the session is ended?
How do we represent comments in oracle?
What are temporal data types in oracle?
How to set up autotrace for a user account?
What privilege is needed for a user to create views in oracle?
How to shutdown your 10g xe server from command line?
What is a Database instance ? Explain?
what are the things that you consider while creating indexes on partitioning tables?
How to download oracle database 10g xe?
Why does Oracle not permit the use of PCTUSED with indexes?
how to get second highest sal of emp table
What are the four Oracle system processes that must always be up and running for the database to be useable?