oracle的触发器怎么限制表里新增的字段?

日期:2018-01-22 09:50:42 人气:1

oracle的触发器怎么限制表里新增的字段?

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
    A+
热门评论