给你一个例子:
CREATE OR REPLACE TRIGGER "DOM"."TR_TAB_FILE" AFTER INSERT ON "DOM"."TAB_FILE" REFERENCING OLD AS OLD NEW AS inserted FOR EACH ROW
DECLARE
OutputFile UTL_FILE.FILE_TYPE;
var_a varchar(20);
BEGIN
OutputFile := UTL_FILE.FOPEN('c:\txt','tab.txt','a');
UTL_FILE.PUTLINE(OutputFile,'insert into TABLE(id, name, ...)');
UTL_FILE.PUTLINE(OutputFile,'values(');
var_a:=:inserted.id;
UTL_FILE.PUTF(OutputFile,'%s,',var_a);
var_b:=:inserted.name;
UTL_FILE.PUTF(OutputFile,'%s,',var_b);
UTL_FILE.PUTLINE(OutputFile,')');
UTL_FILE.FCLOSE(OutputFile);
END;
/
注意,要在init.ora中加入utl_file_paht=c:\txt,指定路径
CREATE OR REPLACE TRIGGER "DOM"."TR_TAB_FILE" AFTER INSERT ON "DOM"."TAB_FILE" REFERENCING OLD AS OLD NEW AS inserted FOR EACH ROW
DECLARE
OutputFile UTL_FILE.FILE_TYPE;
var_a varchar(20);
BEGIN
OutputFile := UTL_FILE.FOPEN('c:\txt','tab.txt','a');
UTL_FILE.PUTLINE(OutputFile,'insert into TABLE(id, name, ...)');
UTL_FILE.PUTLINE(OutputFile,'values(');
var_a:=:inserted.id;
UTL_FILE.PUTF(OutputFile,'%s,',var_a);
var_b:=:inserted.name;
UTL_FILE.PUTF(OutputFile,'%s,',var_b);
UTL_FILE.PUTLINE(OutputFile,')');
UTL_FILE.FCLOSE(OutputFile);
END;
/
注意,要在init.ora中加入utl_file_paht=c:\txt,指定路径
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货