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 the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to handle a single quote in oracle sql?
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.
How to start your 10g xe server from command line?
Please explain drop constraint oracle?
How to install oracle odbc drivers?
What are the major difference between truncate and delete?
How to set a transaction to be read only in oracle?
Can multiple cursors being opened at the same time?
What are the built-in functions used for sending Parameters to forms ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do you tell what your machine name is and what is its IP address?
What is the relation of a user account and a schema in oracle?
