Oracle 插入之前/之后，更新，删除触发器在SQL * Plus上工作，但不在SQL Developer中

set SERVEROUTPUT ON;
create or replace trigger bi_superheroes
before insert ON superheroes
for each row
ENABLE
Declare
v_user varchar2(20);
Begin
Select user into v_user from dual;
DBMS_OUTPUT.PUT_LINE('You have inserted one hero' || v_user);
end;
复制