3,491
社区成员
发帖
与我相关
我的任务
分享
insert into test2 values(ora_login_user, to_char(sysdate,'DD/MM/YYYY HH24:MI:SS'));
CREATE OR REPLACE TRIGGER TR1_table_A BEFORE UPDATE OR INSERT ON A FOR EACH ROW
BEGIN
IF dbms_ddl.is_trigger_fire_once('dms', 'TR1_table_A') THEN
insert into test1 values('dms', to_char(sysdate,'DD/MM/YYYY HH24:MI:SS'));
ELSE
insert into test1 values('', to_char(sysdate,'DD/MM/YYYY HH24:MI:SS'));
END IF;
END;