declare
eno emp.empno%type;
sal emp.sal%type;
begin
eno:=&en;
select sal into sal from emp where empno=eno;
dbms_output.put_line('员工编号:'||eno||'员工工资:'||sal);
exception
when no_data_found then
dbms_output.put_line('没有此雇员');
end;
eno emp.empno%type;
sal emp.sal%type;
begin
eno:=&en;
select sal into sal from emp where empno=eno;
dbms_output.put_line('员工编号:'||eno||'员工工资:'||sal);
exception
when no_data_found then
dbms_output.put_line('没有此雇员');
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货