Why we use stored procedure instead of query?


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

Post New Answer

More SQL PLSQL Interview Questions

Is primary key always clustered index?

0 Answers  


What is auto increment feature in sql?

0 Answers  


What is cursor and why it is required?

0 Answers  


how to include comments in sql statements? : Sql dba

0 Answers  


package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,






What is pl/sql table? Why it is used?

0 Answers  


How to handle bulk data?

0 Answers  


what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  


What is the difference between sum and count in sql?

0 Answers  


table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  


what is the forward decleration in packages?

1 Answers  


What is pl/sql language case sensitive?

0 Answers  


Categories