Oracle存储过程总结(一、基本应用)（Summary of Oracle stored procedure (i. basic application)）.docVIP

Oracle存储过程总结(一、基本应用)（Summary of Oracle stored procedure (i. basic application)） Establish stored procedures or functions A stored procedure or function is a PL/SQL program in an ORACLE database that can be called directly or indirectly by the user. The main advantages of using stored procedures and functions are: 1. Effectiveness: in the client/server architecture, the client applies the requirement for SQL to the database server. As the number of users increases, the SQL request increases continuously, making the network quickly become a running bottleneck. Use stored procedures can make the