select * into row_dept from dept where deptno=:new.deptno; 如果这里没有找到数据,会报异常,需要用exception来处理。 declare row_dept dept%rowtype; begin select * into row_dept from dept where deptno = :new.deptno; insert into emp (empno, ename, deptno, job, hiredate) values (:new.empno, :new.ename, :new.deptno, :new.job, :new.hiredate); exception when no_data_found then insert into dept (deptno, dname) values (:new.deptno, :new.dname);
end tri_insert_view;
select * into row_dept from dept where deptno=:new.deptno; 如果这里没有找到数据,会报异常,需要用exception来处理。 declare row_dept dept%rowtype; begin select * into row_dept from dept where deptno = :new.deptno; insert into emp (empno, ename, deptno, job, hiredate) values (:new.empno, :new.ename, :new.deptno, :new.job, :new.hiredate); exception when no_data_found then insert into dept (deptno, dname) values (:new.deptno, :new.dname);
如果这里没有找到数据,会报异常,需要用exception来处理。
declare
row_dept dept%rowtype;
begin
select * into row_dept from dept where deptno = :new.deptno; insert into emp
(empno, ename, deptno, job, hiredate)
values
(:new.empno, :new.ename, :new.deptno, :new.job, :new.hiredate);
exception
when no_data_found then
insert into dept (deptno, dname) values (:new.deptno, :new.dname);
end tri_insert_view;
如果这里没有找到数据,会报异常,需要用exception来处理。
declare
row_dept dept%rowtype;
begin
select * into row_dept from dept where deptno = :new.deptno; insert into emp
(empno, ename, deptno, job, hiredate)
values
(:new.empno, :new.ename, :new.deptno, :new.job, :new.hiredate);
exception
when no_data_found then
insert into dept (deptno, dname) values (:new.deptno, :new.dname);
end tri_insert_view;3Q,问题解决了,书上的内容都能错,唉