plsql 引用型变量

set serveroutput on

declare

pename emp.ename%type;
psal emp.sal%type;

begin

select ename,sal into pename,psal  from emp   where empno=7839;
dbms_output.put_line(pename||'的薪水是'||psal);
end;
/

 

posted @ 2019-06-02 18:40  小啊菜鸡  阅读(515)  评论(0编辑  收藏  举报