示例(scott用户下得emp表)
set serveroutput on;
declare
name1 varchar2(10);
begin
select ename into name1 from emp where empno=&no;
dbms_output.put_line('雇员名:'||name1);
exception
when NO_DATA_FOUND then
dbms_output.put_line('该雇员不存在');
end;