/SQL/Advantages of stored procedures sql

Advantages of stored procedures sql

A Stored Procedure can be used as a 
modular programming which means create once, 
store and call for several times whenever
it is required. This supports faster execution.
It also reduces network traffic and
provides better security to the data.

Disadvantages of stored procedures sql

Disadvantage:
The only disadvantage of Stored Procedure 
is that it can be executed only in the
database and utilizes more memory in 
the database server.

Similar codes

8 votes324 views3 answers
Oracle auto_increment
SQL
4 votes353 views2 answers
Sqlalchemy_database_uri for mysql
SQL
4 votes329 views1 answer
Oracle error line
SQL
13 votes336 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote527 views1 answer
The differnece between to values in sql
SQL
40 votes364 views6 answers
Update table mysql
SQL
0 vote336 views1 answer
Basic structure of sql expression having clause
SQL
1 vote378 views4 answers
How to check table in postgresql from terminal
SQL
20 votes322 views3 answers
SQL query rename table
SQL
0 vote344 views1 answer
How to find symmetric pairs in sql
SQL