PL// work 06

--예제 1) 사원번호 입력받고 그 사원의 급여에 세금을 출력하라( 세금은 5%로 가정한다)

ACCEPT u_empno PROMPT '사원 번호를 입력하세요'

DECLARE
    u_sal EMPLOYEES.salary%TYPE := 1000;
    u_salTotal NUMBER;
BEGIN
    SELECT salary INTO u_saltotal
    FROM employees
    WHERE employee_id = &u_empno;
    
    SYS.dbms_output.put_line(&u_empno || '번 사원의 급여 : ' || u_salTotal);
    
    
    UPDATE employees
    SET salary = salary*0.05
    WHERE employee_id = &u_empno;
    
    SELECT salary INTO u_saltotal
    FROM employees
    WHERE employee_id = &u_empno;
    
    SYS.dbms_output.put_line(&u_empno || '번 사원의 급여의 세금은(세금 5%) : ' || u_salTotal);

END;
/