17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure Happy_test(v_emplid in varchar2) is
v_Ename varchar2(20);
v_cnt number;
begin
--判断是不是有数据,如果查不到数据,执行“ select t.ename into v_Ename from employee t where t.emplid=v_emplid; ”就报错
select count(0) into v_cnt from employee t where t.emplid=v_emplid;
if v_cnt>0 then
--我用空值测试了没报错
select t.ename into v_Ename from employee t where t.emplid=v_emplid;
update employee set cname=v_Ename where t.emplid=v_emplid;
end if;
end Happy_test;