Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / krishna kant kumar
The UNION operator returns all rows from two or multiple tables and eliminates any duplicate rows but the UNION ALL operator returns from both queries, including all duplications.
The UNION operator can use DISTINCT keyword but the UNION ALL cannot it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle update statement with inner join ?
How to use attributes of the implicit cursor in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
 What are the oracle DML commands possible through an update strategy?
What is the difference between primary key and unique key and foreign key in oracle?
Explain integrity constraint?
Difference between oracle's plus (+) notation and ansi join notation?
How to experiment a data lock in oracle?
Which is better Oracle or MS SQL? Why?
Can you create a synonym without having a table?
What are the different oracle database objects?
What is a trigger oracle?
How to list all indexes in your schema?
How to create additional tablespaces for an new database?
