PLSQL:
查询当前用户下的所有触发器:
select trigger_name,trigger_body from user_triggers;
查询当前用户下,某个表的触发器
select trigger_name,trigger_body from user_triggers where table_name='table_name;
查询所有触发器:
select owner,trigger_name,table_name from dba_triggers;
PLSQL:
查询当前用户下的所有触发器:
select trigger_name,trigger_body from user_triggers;
查询当前用户下,某个表的触发器
select trigger_name,trigger_body from user_triggers where table_name='table_name;
查询所有触发器:
select owner,trigger_name,table_name from dba_triggers;