Oracleのトリガー(trigger)を確認する方法

2022年10月5日

環境
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
SQL*Plus: Release 12.2.0.1.0

操作方法
1.トリガーを確認します

SELECT * FROM USER_TRIGGERS;

SELECT * FROM USER_TRIGGERS;

2.トリガー名、テーブル名、状態を確認します

SELECT TRIGGER_NAME, TABLE_NAME, STATUS FROM USER_TRIGGERS;

SELECT TRIGGER_NAME, TABLE_NAME, STATUS FROM USER_TRIGGERS;

3.トリガーのソース(TRIGGER_BODY)を確認します
書式
SELECT TRIGGER_BODY FROM ALL_TRIGGERS
WHERE TRIGGER_NAME = 'トリガー名称’;

使用例

SELECT

TRIGGER_BODY

FROM

ALL_TRIGGERS

WHERE

TRIGGER_NAME = 'TRG_USER_MAST_LOCK';

SELECT TRIGGER_BODY FROM ALL_TRIGGERS WHERE TRIGGER_NAME = 'TRG_USER_MAST_LOCK';

SELECT
  TRIGGER_BODY 
FROM
  ALL_TRIGGERS 
WHERE
  TRIGGER_NAME = 'TRG_USER_MAST_LOCK';

結果

BEGIN

INSERT INTO S_USER_MAST_LOCK VALUES(

:NEW.USER_NO,

:NEW.LOCK_FLG);

END;

BEGIN INSERT INTO S_USER_MAST_LOCK VALUES( :NEW.USER_NO, :NEW.LOCK_FLG); END;

BEGIN
    INSERT INTO S_USER_MAST_LOCK VALUES(
                :NEW.USER_NO,
                :NEW.LOCK_FLG);
    END;

Posted by arkgame