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 rename an index?

1072

How would you go about verifying the network name that the local_listener is currently using?

2049

Explain the use of record length option in exp command.

1067

Explain the use of file option in exp command.

1130

What is the difference between a hot backup and a cold backup in oracle?

1015

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

Explain joins in oracle?

1036

What the is the diff between local index and global index. give some example.

1639

How to convert raw data type into text in oracle? Explain

993

What are the data types in oracle?

1040

How to use "for" statements in oracle?

1074

What is an oracle data file?

1103

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1916

What is the difference between substr & instr functions?

1228

Explain do view contain data?

1011