exceptionwithempno.sql

来自「codding for pszone one can use it at pl」· SQL 代码 · 共 11 行

declare
emp_number integer:=&empno;
emp_name varchar2(10);
begin
select ename into emp_name from emp where empno=emp_number;
dbms_output.put_line('employee name is '||emp_name);
exception
when no_data_found then
dbms_output.put_line('no such employee '||emp_number);
end;
/