union displays only different values in the multiple table. but union all

what is the difference between UNION AND UNIONALL

Question Posted / vaithianathan

Answer Posted / vaithianathan

union displays only different values in the multiple table.
but union all displays all related values.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is Java Pool in Oracle?

1145

What is a cursor variable?

1103

What are oracle functions?

1009

How to assign data of the deleted row to variables?

1056

if you ctreate table identity

2353

Can we use bind variables in oracle stored procedure?

933

Please explain joins in oracle?

1048

How to create a new tablespace in oracle?

967

Explain an exception and its types?

1052

How to put more than 1000 values into an oracle in clause?

1012

What is the exact use of Collections?

2130

What are the benefits of ordbms?

1070

what are the default admin accounts in Oracle 10g ?

953

How can we delete duplicate rows in a table?

954

How to create a table in a specific tablespace?

948