728x90 반응형 Trigger1 oracle sql tigger create or replace trigger triger_testbeforeupdate on deptfor each rowbegindbms_output.put_line('변경 전 컬럼 값:'|| :old.dname);dbms_output.put_line('변경 후 컬럼 값:'|| :new.dname);end;/ update dept set dname='총무부' where deptno='30'; create or replace trigger check_deletebefore delete on empbeginif to_char(sysdate,'DY') in ('목','금') thenraise_application_error(-20007,'목,금요일은 안됨');end if;end;/ delete from e.. 2015. 10. 12. 이전 1 다음 728x90 반응형