给你一个例子吧:CREATE OR REPLACE TRIGGER "TR_TAB_FILE" AFTER INSERT ON "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 t_person(person_id, db_code, dob...)'); UTL_FILE.PUTLINE(OutputFile,'values('); var_a:=:inserted.person_id; UTL_FILE.PUTF(OutputFile,'%s,',var_a); var_b:=:inserted.db_code; UTL_FILE.PUTF(OutputFile,'%s,',var_b); UTL_FILE.PUTLINE(OutputFile,')'); UTL_FILE.FCLOSE(OutputFile); END; /
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 t_person(person_id, db_code, dob...)');
UTL_FILE.PUTLINE(OutputFile,'values(');
var_a:=:inserted.person_id;
UTL_FILE.PUTF(OutputFile,'%s,',var_a);
var_b:=:inserted.db_code;
UTL_FILE.PUTF(OutputFile,'%s,',var_b);
UTL_FILE.PUTLINE(OutputFile,')');
UTL_FILE.FCLOSE(OutputFile);
END;
/