2020 10 05 sql 과제 procedure pro_3

 CREATE OR REPLACE PROCEDURE updatedept_test ( p_deptno IN dept_test.deptno%TYPE ,

p_dname IN dept_test.dname%TYPE, p_loc IN dept_test.loc%TYPE )

IS

BEGIN 

UPDATE dept_test SET deptno = p_deptno, dname = p_dname , loc = p_loc

WHERE deptno =  p_deptno ;

END;

/

exec updatedept_test( 99, 'ddit_m' , 'daejeon' ) ;

SELECT *

FROM dept_test;