create or replace trigger tri_test before INSERT OR DELETE OR UPDATE on aa for each row declare -- local variables here l_user VARCHAR2(20); BEGIN SELECT USER INTO l_user FROM dual; IF USER='u1' THEN IF inserting THEN INSERT INTO u2.t2(action) VALUES('INSERT'); ELSIF updating THEN INSERT INTO u2.t2(action) VALUES('UPDATE'); ELSE INSERT INTO u2.t2(action) VALUES('DELETE'); END IF; END IF; end tri_test;
create or replace trigger tri_test before INSERT OR DELETE OR UPDATE on aa for each row declare -- local variables here l_user VARCHAR2(20); BEGIN SELECT USER INTO l_user FROM dual; IF l_user='u1' THEN --错了,这里应该是l_user IF inserting THEN INSERT INTO u2.t2(action) VALUES('INSERT'); ELSIF updating THEN INSERT INTO u2.t2(action) VALUES('UPDATE'); ELSE INSERT INTO u2.t2(action) VALUES('DELETE'); END IF; END IF; end tri_test;
before INSERT OR DELETE OR UPDATE on aa
for each row
declare
-- local variables here
l_user VARCHAR2(20);
BEGIN
SELECT USER INTO l_user FROM dual;
IF USER='u1' THEN
IF inserting THEN
INSERT INTO u2.t2(action) VALUES('INSERT');
ELSIF updating THEN
INSERT INTO u2.t2(action) VALUES('UPDATE');
ELSE
INSERT INTO u2.t2(action) VALUES('DELETE');
END IF;
END IF;
end tri_test;
before INSERT OR DELETE OR UPDATE on aa
for each row
declare
-- local variables here
l_user VARCHAR2(20);
BEGIN
SELECT USER INTO l_user FROM dual;
IF l_user='u1' THEN --错了,这里应该是l_user
IF inserting THEN
INSERT INTO u2.t2(action) VALUES('INSERT');
ELSIF updating THEN
INSERT INTO u2.t2(action) VALUES('UPDATE');
ELSE
INSERT INTO u2.t2(action) VALUES('DELETE');
END IF;
END IF;
end tri_test;