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

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

Please Help Members By Posting Answers For Below Questions

What is an Oracle Instance?

1105

Â What are the oracle DML commands possible through an update strategy?

1042

How to download oracle database 10g xe?

1005

Why should I use oracle database?

976

How to put more than 1000 values into an oracle in clause?

1013

How to check the oracle tns settings?

1032

How to list all indexes in your schema?

1078

Can we write dml statement in function in oracle?

1068

What is BBED in Oracle?

1136

How to enter a new row into a table interactively?

994

How do I find my oracle client driver version?

1020

types of indexes and the rationale behind choosing a particular index for a situation.

2498

What do you mean by a deadlock?

1051

What is a user role in oracle?

1102

What is parameterized cursor in oracle?

1118