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?
- 2 Answers
- 4499 Views
- Zensar, I also Faced
- E-Mail Answers
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
How to select some rows from a table in oracle?
How to assign values to variables?
Give the different types of rollback segments.
How can Oracle users be audited?
In which language oracle has been developed?
How to do paging with oracle?
what is normalisation?what are its uses?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the difference between I and G in Oracle?
Give the various rollback segment states.
How to load a large xml file?
What is an oracle database table?
How do we represent comments in oracle?
What is tns service name?
Explain an integrity constrains?
