oracle 过程存储

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;