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