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 the usage of control file in oracle?

1139

How to end the current transaction in oracle?

1063

What are triggers in oracle?

1094

How to resolve the ORA-39133 error in Oracle?

1179

Explain the use of grant option in exp command.

1106

How to commit the current transaction in oracle?

1176

master table and child table performances and comparisons in Oracle ?

2194

How do you find current date and time in oracle?

1096

What do database buffers contain?

1074

Explain the characteristics of oracle dba?

1170

What is concurrency in oracle?

1051

What is the difference between online and offline backups?

1125

How to use in conditions in oracle?

1103

Why is oracle used?

978

How to view all columns in an existing table?

975