declare
v_enameemp.ename%type;
v_sal emp.sal%type;
begin
selectename,sal into v_ename,v_sal
fromemp where ename='&no'; //注意 若要输入的时字符变量 必须用“单引号”!!
dbms_output.put_line('name:'||v_ename);
dbms_output.put_line('sal:'||v_sal);
exception
whenNO_DATA_FOUND THEN
dbms_output.put_line('sorry,there is no date found!!');
end;