moozi

오라클연습문제5

create procedure pro2 as vs_emp_name employees.emp_name%TYPE; vs_dep_name departments.department_name%TYPE; begin dbms_output.enable; select a.emp_name, b.department_name into vs_emp_name, vs_dep_name -- 컬럼의 값을 변수에 각각 저장 from employees a, departments b where a.department_id=b.department_id and a.employee_id=100; -- 출력.app에서는 결과값을 사용 못함. dbms_output.put_line(vs_emp_name || '-' || vs_dep_name); en..