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

How to rollback the current transaction in oracle?

1101

What is oracle and what are its different editions?

1118

What are the different pseudo commands? Explain in general?

1121

What is a oracle database?

1105

What is an oracle cursor variable?

1131

material view and view disadvantages?

1122

Explain oracle 12c new features for developers?

1121

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1117

How to loop through a cursor variable?

1124

How to do a full database export?

1150

What is a sub query? What are its various types?

1270

How does Oracle guarantee data integrity of data changes?

2453

Where do you use decode and case statements?

1042

How to load data from external tables to regular tables?

1100

How to get a create statement for an existing table?

1010