Oracle 12cでトリガー(trigger)は確認する方法
環境
Oracle 12.2.0.1.0
操作例
1.トリガーを確認(全ての項目)
SELECT * FROM USER_TRIGGERS
SELECT * FROM USER_TRIGGERS
SELECT * FROM USER_TRIGGERS
2.トリガーを確認(必要な項目)
SELECT TRIGGER_NAME,TRIGGER_TYPE,TABLE_NAME, STATUS FROM USER_TRIGGERS;
SELECT TRIGGER_NAME,TRIGGER_TYPE,TABLE_NAME, STATUS FROM USER_TRIGGERS;
SELECT TRIGGER_NAME,TRIGGER_TYPE,TABLE_NAME, STATUS FROM USER_TRIGGERS;
3.トリガーのソースを確認
SELECT TRIGGER_BODY FROM ALL_TRIGGERS WHERE TRIGGER_NAME = 'トリガー名'
SELECT TRIGGER_BODY FROM ALL_TRIGGERS WHERE TRIGGER_NAME = 'トリガー名'
SELECT TRIGGER_BODY FROM ALL_TRIGGERS WHERE TRIGGER_NAME = 'トリガー名'