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
How do I spool to a csv formatted file using sqlplus?
What is the difference between translate and replace in oracle?
How can you use check constraints for self referential integrity?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the attributes of the cursor?
What is the difference between a primary key & a unique key?
Is there a combination of "like" and "in" in sql?
What is oracle instant client?
Is there any function in oracle similar like group_concat of mysql?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the use of ignore option in imp command.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to see the table columns used in an index?
what is the dual table in oracle?
What is transport network substrate (tns) in oracle?
