Oracle--异常处理
CREATE OR REPLACE TRIGGER tr_insert_empBEFORE INSERT ON employeesFOR EACH ROWBEGIN IF :new.first_name IS NULL OR :new.last_name is null THEN RAISE_APPLICATION_ERROR(-20000,'Employee must have a name.'); END IF;END;????
发布时间: 2013-11-30 22:36:00 作者: rapoo
Oracle--异常处理
CREATE OR REPLACE TRIGGER tr_insert_empBEFORE INSERT ON employeesFOR EACH ROWBEGIN IF :new.first_name IS NULL OR :new.last_name is null THEN RAISE_APPLICATION_ERROR(-20000,'Employee must have a name.'); END IF;END;????