declare
v_sal varchar2(55) ;
v_job varchar2(55) ;
v_date DATE;
begin
select salary, job_id, hire_date into v_sal, v_job, v_date
from employee where employee_id = 120;
dbms_output.put_line(salary);
end;
v_sal varchar2(55) ;
v_job varchar2(55) ;
v_date DATE;
begin
select salary, job_id, hire_date into v_sal, v_job, v_date
from employee where employee_id = 120;
dbms_output.put_line(salary);
end;