Shulou(Shulou.com)06/03 Report--

Principles for using procedures and functions:

1. If you need to return multiple values and no values, use the procedure; if you only need to return one value, use the function.

2. The procedure is generally used to perform a specified action, and the function is generally used to calculate and return a value.

3. Functions can be called inside SQL statements (such as expressions) to complete complex calculation problems, but procedures cannot be called. So this is a feature of the function.

I. stored procedure

1. Preliminary stored procedure

Stored procedures: implement create or replace procedure movetohistory_1 (o_count out number, error out VARCHAR2) ISV_COU-NT number;V_SUBSCRIBE_ID TI_C_IOM_BUSIFORM.SUBSCRIBE_ID% TYPE to move history tables V_time date: = to_date ('2015-3-20 16-12-24-12-24-12-12-12-12-12-12-12-12-16-12-16-24-24-24-12-12-12-16-24-24-24-24-24-24-24-24-24-24-15-24-24-15-24-24-24-24-24-15-24-15-24-15-24-24-15-24-24-15-24-24-15-24-24-15-24-15-24-24-15-22-24-24-15-22-24-24-24-15-24-24-15-24-24-15-24-24-15-24-15-24-24-15-24-24-15-22-2015-3-20, v_time date: = to_date (' 2015-3-20 16-

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.