17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER del_DML tmp
BEFORE DELETE ON table1
declare
n number;
stmt varchar2(4000);
sql_text ora_name_list_t;
begin
n := ora_sql_txt(sql_text);
FOR i IN 1..n LOOP
stmt := stmt || sql_text(i);
END LOOP;
--insert into table2(userid,str) values(user,stmt);
end;