For the first case it will come : 1,3,2,5,3,4 For the second case it will

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?

Question Posted / sudipta santra

2 Answers
5478 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

Please Help Members By Posting Answers For Below Questions

What is the data pump export utility?

1090

How does Oracle guarantee data integrity of data changes?

2406

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2078

What is flashback in Oracle?

1027

How to do a full database export?

1117

What is an oracle table?

993

What is dual table oracle?

996

How to delete a user account in oracle?

984

How to use values from other tables in update statements using oracle?

1087

what is difference between sql plus and sql*plus? (not sql and sql plus).

3910

Explain an exception and its types?

1082

Explain joins in oracle?

1043

how to clone 9i Database on to 10g Database.

2346

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2019

Explain the use of indexes option in imp command.

1186