exceptionwithempno.sql

codding for pszone one can use it at playstation zones

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;
/