declare
L_sal number(4);L_var number(4);L_job varchar2(20);
BEGIN
SELECT empno INTO L_var FROM EMP WHERE ename= 'KING';
SELECT sal INTO L_sal FROM EMP WHERE empno = L_var;
SELECT job INTO L_job FROM EMP WHERE empno = L_var;
dbms_output.put('king : '||l_job);
dbms_output.put_line('-> empno : '||L_var|| ' sal :'||L_sal );
END;
/