plsql 记录型变量

set serveroutput on

declare

emplist emp%rowtype;


begin

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

 

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