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

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

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.