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
How to build data dictionary view an new database?
What are the different types of modules in oracle forms?
Explain an integrity constrains?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to lock and unlock a user account in oracle?
What is a dead lock in oracle?
How do I know if oracle client is installed on windows?
what is the difference between substr and instr function in oracle?
How to update values in a table in oracle?
What is a read only transaction in oracle?
Explain an exception and its types?
What do you understand by database schema and what does it hold?
How to create a new view in oracle?
How to establish administrator authentication to the server?
