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 end the current transaction in oracle?

960

Point out the difference between user tables and data dictionary?

930

How to assign data of the deleted row to variables?

1012

How many categories of data types in oracle?

952

What are the different windows events activated at runtime ?

2832

How would you begin to troubleshoot an ORA-3113 error?

2022

What is redo log?

1003

Can we convert a date to char in oracle and if so, what would be the syntax?

956

What is bulk collect in oracle?

953

In oracle there is column command, how will you explain that?

964

What are the varoius components of physical database structure of oracle database?

942

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5328

Explain compound trigger in oracle?

982

Can we write insert statement in function in oracle?

1025

What is open database communication (odbc) in oracle?

945