what is the difference between UNION AND UNIONALL

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a subquery in oracle?

578


Explain the use of file option in exp command.

601


How a database is related to tablespaces?

580


What are the varoius components of physical database structure of oracle database?

569


How many types of cluster table in Oracle?

577






How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2395


What is data block in Oracle?

618


How can we force the database to use the user specified rollback segment?

561


How to use windows user to connect to the server?

534


What is the difference between I and G in Oracle?

603


How to create an oracle database manually?

568


interview questions with answer for cts

2090


Give the various rollback segment states.

579


What is a snapshot log?

564


How to connect the oracle server as sysdba?

633