Trigger

create or replace trigger update_notnull
  before INSERT OR DELETE OR UPDATE ON  mm_ry
  FOR EACH ROW

BEGIN
  IF updating THEN
       IF :NEW.ID_FLAG is NULL THEN
         raise_application_error(-20001, 'ID_FLAG IS NOT NULL');
       END IF;
    END IF;
END;

posted @ 2015-03-12 18:13  letmedown  阅读(111)  评论(0)    收藏  举报