Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 45829 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / anjani kumar
Union will return only distinct values from two tables.
Union all will return duplicate values from the two tables
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
what is a control file ? : Sql dba
Explain spool.
What is data manipulation language?
Explain sql data types?
Show code of a cursor for loop.
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is a column in a table?
What is integrity in sql?
When can we use the where clause and the having clause?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
explain advantages of myisam over innodb? : Sql dba
What do you mean by dbms? What are its different types?
Is sql harder than python?
What is rank dense_rank and partition in sql?
