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 command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,


In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,


is it possible to pass an object or table to a procedure as an argument?

0 Answers  


What is RAC in oracle?

7 Answers   MCN Solutions,


how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,






What is delimiter in pl sql?

0 Answers  


What is the main difference between sql and pl/sql?

0 Answers  


why not null constraint showing its constraint type as 'c'

1 Answers  


How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,


What is vector point function?

0 Answers  


Where not exists in sql?

0 Answers  


What are the types of records?

0 Answers  


Categories