declare
nodatafound exception;
v_ename emp.ename%type:=’&ename’;
v_empno emp.empno%type;
v_sal emp.sal%type;
n number;
begin
select count(*),empno,sal into n,v_empno,v_sal from emp where ename=v_ename;
if n=0 then
raise nodatafound;
end if;
dbms_output.put_line(v_ename||‘的编号’||v_empno||‘薪水’||v_sal);
exception
when nodatafound then
raise_application_error(-20004,‘该雇员不存在’);
when others then
dbms_output.put_line(‘其他异常’);
end;
declare
v_ename emp.ename%type:=’&ename’;
v_empno emp.empno%type;
v_sal emp.sal%type;
n number(10);
begin
select count(*) into n from emp where ename=v_ename;
if n =0 then
dbms_output.put_line(v_ename||’ 该雇员不存在 ‘);
elsif n =1 then
select empno,sal,ename into v_empno,v_sal,v_ename from emp where ename=v_ename;
dbms_output.put_line(v_ename||’ empno:’||v_empno||’ sal:’||v_sal);
else
dbms_output.put_line(v_ename||’ 该雇员存在同名’);
end if;
end;
评论
有用 0
