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
What happens to the data files if a tablespace is dropped?
How to shutdown your 10g xe server?
What is the relation of a user account and a schema in oracle?
What are the various types of snapshots ?
what's query optimization and without use of IN AND Exist can we get another way data from query
Can you have more than one content canvas view attached with a window ?
How to select an oracle system id (sid)?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What are privileges and grants?
How to rename an existing table?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to create a new oracle data file?
How to use "startup" command to start default instance?
How to create a testing table in oracle?