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 are the parameters that we can pass through a stored procedure?
Can we insert data in view oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the use of compress option in exp command.
How to retrieve the count of updated rows?
How to update values on multiple rows in oracle?
How to apply filtering criteria at group level in oracle?
What is meant by recursive hints in oracle?
What do you understand by a database object? Can you list a few of them?
What is a trigger and what are its types in oracle?
How to use subqueries in the from clause in oracle?
How to rename an index in oracle?
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?
How to bring a tablespace offline?
How do I manually create a database in oracle?
