trigger 사용

1. 테이블 확인SQL> select * from scott.tmp_result; 2. history 테이블 생성SQL> create table scott.table_history as select ename, sysdate dt from scott.tmp_result where 1=2;Table created. 3. trigger 생성create or replace trigger table_history_triggerbefore insert on scott.tmp_resultfor each rowbegin if inserting then insert into scott.table_history values(:new.ename, sysdate); end if;end table_hi..

2024.11.13