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
最后
以上就是善良音响最近收集整理的关于oracle触发器锁表,禁止oracle表的触发器trigger的全部内容,更多相关oracle触发器锁表,禁止oracle表内容请搜索靠谱客的其他文章。
本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
发表评论 取消回复