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

2 Answers
5474 Views
Zensar, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the data pump import utility?

1040

What happens if the update subquery returns multiple rows?

1120

How to use subqueries in the from clause in oracle?

1114

What is index in Oracle?

1077

Is primary key indexed by default in oracle?

993

List the various oracle database objects?

1061

Hi Can any one tell me what are the API's used in requisition import.

1926

How to Truncate Table in Oracle

1162

How to define a specific record type?

1088

What are the attributes that are found in a cursor?

1081

How to divide query output into groups in oracle?

994

How to use subqueries with the exists operator in oracle?

1028

How to create an oracle testing table?

1075

How to assign a tablespace to a users in oracle?

1048

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2473