What are Stored Procedures and When would we Use Them?
Answer Posted / hr@tgksolutions.com
Precompiled sets of SQL statements that are kept in the database are called stored procedures. They
Encapsulate business logic and intricate SQL queries.
Reduce network traffic (client-server round trips) to boost performance.
By using parameterized queries to limit access to data, you may improve security.
Make sure it is reusable and consistent across many applications.
When carrying out repetitive operations like data validation, business rule enforcement, or batch processing, stored procedures are especially helpful.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to select the first record in a given set of rows?
What's difference between dbms and rdbms ?
Write about Transaction Management in Oracle 9i?
What do you understand by data redundancy?
What are the integrity rules in dbms?
What is 1nf 2nf 3nf in dbms?
Which two statements are true about a foreign key?
What is advantages of progress actional?
What is dbms introduction?
What is the purpose of sql?
What is a checkpoint in dbms?
Who invented schema theory?
How can you perform pattern matching in sql?
Mention the different types of cursor?
Explain environment of openedge?