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 @ 2015-06-29 22:46  nick_huang  阅读(1824)  评论(0编辑  收藏  举报