Oracle存储过程

2022-10-20 20:29:45

-- 编写
create or replace procedure tianjin_risk_forecast is
begin

execute immediate 'TRUNCATE TABLE table_name';
insert /*+append*/ into table_name
(identifynumber
,customer_name
,risk_score
)
SELECT /*+PARALLEL(8)*/
   identifynumber
   ,customer_name
   ,risk_score
FROM
ods_user.ods_risk_customer
;
COMMIT;

end tianjin_risk_forecast;

-- 调用
BEGIN

   tianjin_risk_forecast;
end;