禁止oracle表的觸發器trigger

czxin788發表於2020-10-14
Oracle觸發器
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章