CREATE OR REPLACE PROCEDURE insert_emp_proc( P_EID IN EMPLOYEES.EMPLOYEE_ID%TYPE, P_NAME IN EMPLOYEES.EMP_NAME%TYPE, P_HDATE IN EMPLOYEES.HIRE_DATE%TYPE, P_SAL NUMBER) -- 여기까지가 매개변수를 정리해 주는 곳 IS V_CNT NUMBER(1) :=0; BEGIN SELECT COUNT(*) INTO V_CNT --0또는 1이 나옴 FROM EMPLOYEES WHERE EMPLOYEE_ID=P_EID; IF V_CNT>=1 THEN UPDATE EMPLOYEES SET EMP_NAME=P_NAME, SALARY=P_SAL, HIRE_DATE = P_H_DATE WHERE E..