For the first case it will come : 1,2,3,3,4,5 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 / anuradha

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

Please Help Members By Posting Answers For Below Questions

What is a table in oracle?

1020

What is oracle server autotrace in oracle?

1220

Explain joins in oracle?

1090

What is oracle datasource?

1039

How to enter a new row into a table interactively?

1048

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

How to use null as conditions in oracle?

1125

What is the sid in oracle?

1032

What is the data pump import utility?

1074

In which language oracle has been developed?

1134

What is SQL access advisor in Oracle?

1229

What is a trigger and what are its types in oracle?

1152

What are transaction isolation levels supported by oracle?

1114

How do I know if oracle client is installed on windows?

1092

What are the limitations of check constraint?

1073