Why are stored procedures used?
Answer / Gaurav Agarwal
"Stored Procedures in PostgreSQL are used to encapsulate SQL code, parameters, and transaction control for reusable program modules. They help improve performance by reducing network traffic by storing the code on the server."
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create table with timestamp in postgres?
What is a delete query?
What is the advantage of postgresql?
Is postgres a mpp?
How do you insert rows and columns?
How will you add a new style in a table?
How to execute a function in postgresql?
What port does postgresql listen on?
What are indexes in postgresql?
Explain multi version concurrency control.
Explain about functions in PostgreSQL?
Is postgresql is nosql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)