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 / 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 |
Post New Answer View All Answers
How to connect to the server with user account: sys?
What is hot backup and logical backup?
How to define an external table with a text file?
Explain what does a control file contain?
What is merge statement used for?
Why use resource manager in Oracle?
How translate command is different from replace?
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.
What happens in oracle commit?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How a database is related to tablespaces?
How to end the current transaction in oracle?
Are truncate and delete commands same? If so why?
How to export data to a csv file?
What is the usage of merge statement?