Oracle/PL/SQL

15일차 # 2-29: 치환 변수 + 바인드 변수

Bohemian life 2012. 4. 24. 21:04

        var a varchar2(30)


declare

 v_empno number := &sv_empno;

begin

 select ename into :a

 from emp

 where empno = v_empno;

end;

/


print a

A

--------------------------------



Enter value for sv_empno: 7788


print a

A

--------------------------------

SCOTT