Oracle PLSQL Demo - 02.SELECT INTO单行赋值[SELECT INTO variables]

declare
    v_sal number;
begin
    select t.sal into v_sal from scott.emp t where rownum <= 1;
    dbms_output.put_line(v_sal);
end;

 

posted @   nick_huang  阅读(1833)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示