What are the advantages of stored procedure?


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

Post New Answer

More SQL PLSQL Interview Questions

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,


What is the difference between partition and index?

0 Answers  


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  


What is left join in postgresql?

0 Answers  


how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,






How to use boolean type in select statement?

0 Answers  


sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,


Advantages and disadvantages of stored procedure?

0 Answers  


What are the uses of merge?

0 Answers  


Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  


Explain select statements in sql?

0 Answers  


What are sql functions? Describe the different types of sql functions?

0 Answers  


Categories