darcyjoven#library#触发器1

## 触发器 ```sql CREATE OR REPLACE TRIGGER tic_TRIGGER AFTER INSERT OR DELETE OR UPDATE ON tic_file for each row DECLARE V_TYPE TIC_LOG.L_TYPE % TYPE; BEGIN IF INSERTING THEN --INSERT触发 V_TYPE := 'INSERT'; DBMS_OUTPUT.PUT_LINE('记录已经成功插入，并已记录到日志')