查看触发器
SELECT table_name,TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT, TABLE_OWNER, BASE_OBJECT_TYPE, REFERENCING_NAMES, STATUS, ACTION_TYPE FROM all_triggers where table_name ='PARTY_ROLE';
删除触发器
DROP TRIGGER trigger_name;
创建触发器
Create trigger party_role Before update or delete
of party_role_no
On party_role
Begin
Raise_application_error(-20001, '联系吴西');
End;