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?
Answer Posted / 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 |
Post New Answer View All Answers
Are truncate and delete commands same? If so why?
How view is different from a table?
What would you do with an in-doubt distributed transaction?
Which environment variables are absolutely critical in order to run the OUI?
What is a nvl function? How can it be used?
Explain about integrity constraint?
What is connection pool in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How can we delete duplicate rows in a table?
What is columnar storage what is the advantage?
Differentiate between function and procedure in oracle.
What is difference between sid and service name in oracle?
How to change system global area (sga) in oracle?
how may join possible between (requisition with purchase order)
How to convert times to characters in oracle?