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 cursor in oracle?

650

Where do we use decode and case statements?

563

What is an anonymous block?

625

How to create a table index in oracle?

659

Give the various rollback segment states.

579

What is difference between cartesian join and cross join?

591

Can we insert data in view oracle?

535

Respected sir, Please send me technical questions related to oracle apps..

1379

What is the difference between substr & instr functions?

597

Why do we need oracle client?

511

What is the relationship among database, tablespace and data file?

542

What is a private synonym?

1086

How do I limit the number of rows returned by an oracle query after ordering?

633

Is insert autocommit in oracle?

602

Can a parameter be passed to a cursor?

600