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 recovery manager in Oracle?

990

What is Library Cache in Oracle?

1073

What is using clause and give example?

996

what are actual and formal parameters?

1047

How to create a new view in oracle?

1012

Can we connect to ORACLE db using Windows Authentication?

1178

if you ctreate table identity

2310

what is port in oracle? how is it related to database application.

1892

What do you mean by merge in oracle?

936

how to join query for one source type is oracle another source type is sql server ?

2375

What is instant client oracle?

972

Does oracle charge for java?

1005

Explain the use of log option in exp command.

1045

How can I combine multiple rows into a comma-delimited list in oracle?

998

Can we call procedure inside function in oracle?

1016