ORACLE stored procedure in keyword is used
I. description of the problem:
Write a stored procedure (only half of it, which can explain the proposition)
CREATE OR REPLACE PROCEDURE "MONTH_RPT_CENTER_STU_DATA_PROC" (centerIds in VARCHAR2) AS mlockdate date BEGIN/* creator: fengcl creation time: January 23, 2018.UPDAT: update time: parameter: central number (string type) function: when calling, delete the data of the specified center from the intermediate table first Then re-query the data inserted into the designated center into the intermediate table * /-- get the lock date of the monthly report select trunc (sysdate,'mm') + to_number (name) into mlockdate from mdm_dic_option where code='monthReportDate' and dic_code='system_set_001' If mlockdate=add_months (trunc (sysdate,'mm'),-1) and RPT_DATE
