禁止oracle表的觸發器trigger

czxin788發表於2020-10-14
SQL> select OWNER,TRIGGER_NAME,STATUS from dba_triggers where TRIGGER_NAME='TR_MTRL_STOCK_THREE_CLOUDHIS';
OWNER			       TRIGGER_NAME		      STATUS
------------------------------ ------------------------------ --------
HRP_xxx		       TR_MTRL_STOCK_THREE_CLOUDHIS   ENABLED
SQL> 
SQL> alter trigger TR_MTRL_STOCK_THREE_CLOUDHIS disable;
Trigger altered.
SQL> 
SQL> select OWNER,TRIGGER_NAME,STATUS from dba_triggers where TRIGGER_NAME='TR_MTRL_STOCK_THREE_CLOUDHIS';
OWNER			       TRIGGER_NAME		      STATUS
------------------------------ ------------------------------ --------
HRP_xxx		       TR_MTRL_STOCK_THREE_CLOUDHIS   DISABLED


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28916011/viewspace-2726970/,如需轉載,請註明出處,否則將追究法律責任。

相關文章