oracle-Stored Procedures

Definition: A stored procedure is a set of SQL statements that are precompiled for the purpose of implementing certain functions.

Advantages: 1, pre-compilation, fast;

2, security, call stored procedures require specific permissions;

3, can be repeated, reduce the development workload

To create a stored procedure method: 1, specify the user through the Sqlplus connection, password, and then use the stored procedure basic syntax to edit the SQL statement (deprecated)

2, through the third-party auxiliary tools (such as: Plsql that is what we often say mailbox), login PLSQ

oracle-Stored Procedures