What is the difference between Union and Union all. Which is faster.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What are the limitations of sql express?

0 Answers  


difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,


Which data type is a composite type?

0 Answers  


Does varchar need length?

0 Answers  


Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,






What is the difference between drop and truncate commands?

0 Answers  


what is 'mysqldump'? : Sql dba

0 Answers  


Why truncate is used in sql?

0 Answers  


What is a sql profiler?

0 Answers  


in a package one procedure is wrong package shows valid or not

4 Answers  


I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  


How exception is different from error?

0 Answers  


Categories