Oracle存储过程(oracle存储过程实例详解)
-- 编写
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;
标签：customer,存储,risk,tianjin,identifynumber,forecast,Oracle,过程,name
来源： https://www.cnblogs.com/kaiyue/p/15577102.html