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 are the differences between interval year to month and interval day to second?

560

How to add another datafile to a tablespace?

585

Why do you create or replace procedures rather that drop and recreate.

554

How to convert times to characters in oracle?

619

How to create a new oracle data file?

571

What is open database communication (odbc) in oracle?

553

Explain what are the different type of segments?

587

Does facebook use oracle?

585

What is a system tablespace?

614

What are the attributes of the cursor?

567

How to omit columns with default values in insert statement in oracle?

584

How to divide query output into groups in oracle?

567

Explain the dml?

606

Explain the use of grant option in imp command.

586

How to connect to a remote server?

571