触发器

查看触发器

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;