Prosedure - Insert, Update, Delete

• Insert

 

--- 쿼리문으로 Insert

create or replace procedure proc_deptInsert2
	(p_deptno in number, p_dname in varchar2, p_loc in varchar2)
is
begin
    insert into dept(deptno, dname, loc) select 51, '운영부', '강원' FROM dual; 
   commit;
end;

 

결과: 추가되었다

 

 

 

--- cmd로 추가하기 

 

 

 

 

• Update

-- 실행문으로 Update

exec proc_deptUpdate(53, 'DBA', '인천');

 

 

 

• Delete

-- 프로시저 실행문

create or replace procedure proc_deptDelete(p_deptno in number)
is
begin
    delete from dept where deptno = p_deptno;
    commit;
end;