CREATE OR REPLACE TRIGGER test_tri_t BEFORE INSERT
ON test_tri
FOR EACH ROW
DECLARE newnum number;
BEGIN
newnum:=:new.num*10;
:new.num := newnum;
END;
/
ON test_tri
FOR EACH ROW
DECLARE newnum number;
BEGIN
newnum:=:new.num*10;
:new.num := newnum;
END;
/