比如说在对表A做Insert或Update操作的时候,将这个值'aaa'插入到表B的inserted_by这个字段: create or replace trigger demo_tri after insert OR update on A REFERENCING OLD AS OLD NEW AS NEW for each row declare begin insert into B (inserted_by) values ('aaa'); end; /
触发器可以按照 1 楼的来写,但是你要知道用户哪些信息可以通过 userenv 函数来获取 userenv 函数的参数: CLIENT_INFO ENTRYID ISDBA LANG LANGUAGE SESSIONID SID TERMINAL
create or replace trigger demo_tri
after insert OR update
on A
REFERENCING OLD AS OLD NEW AS NEW
for each row
declare
begin
insert into B (inserted_by) values ('aaa');
end;
/
userenv 函数的参数:
CLIENT_INFO
ENTRYID
ISDBA
LANG
LANGUAGE
SESSIONID
SID
TERMINAL