개발언어/PL SQL
180326 사원번호 입력 받아서 부서 번호 출력하기
쿵도리
2018. 3. 26. 13:50
<방법 1>
declare
v_did employees.department_id%type;
v_eid employees.employee_id%type :=&empid;
v_dname departments.department_name%type;
begin
select department_id
into v_did
from employees
where employee_id = v_eid;
select department_name
into v_dname
from departments
where department_id = v_did;
dbms_output.put_line(v_dname);
end;
----------------------------------------------------------------
<방법 2>
var b_dname varchar2(30)
declare
v_did employees.department_id%type;
v_eid employees.employee_id%type := &empid;
begin
select department_id
into v_did
from employees
where employee_id = v_eid;
select department_name
into :b_dname
from departments
where department_id = v_did;
end;
print~~~~
/