oracle的触发器怎么限制表里新增的字段?
oracle的触发器怎么限制表里新增的字段?
日期:2018-01-22 09:50:42 人气:1
CREATE OR REPLACE TRIGGER tr_test_1 BEFORE insert on tb_1 FOR each rowdeclare v_11 number;begin select count(1) into v_11 from dual where :new.address like '%-%'; if v_11 > 0 then RAISE_APPLICATION_ERROR(-20600, '不允许出现-'); end