Are stored procedures faster than dynamic sql?


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

Post New Answer

More SQL PLSQL Interview Questions

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,


is mysql query is case sensitive? : Sql dba

0 Answers  


What does inner join mean?

0 Answers  


What is auto increment in sql?

0 Answers  


Can we have two clustered index on a table?

0 Answers  






Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,


how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  


Is sql injection illegal?

0 Answers  


Give which cursor is better for better performance means type of cursors?

2 Answers  


What is the difference between row level and statement level trigger?

0 Answers  


What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  


What is trigger and stored procedure in sql?

0 Answers  


Categories