DATABASE/ORACLE
ORACLE PROCEDURE 쿼리 COMMIT 또는 ROLLBACK
JDK's blog
2017. 2. 16. 16:15
CREATE OR REPLACE PROCEDURE ADJDK.ADD_BOARD(IN_VAR IN VARCHAR2)
IS
BEGIN
--BEGIN
UPDATE BOARDTABLE
SET B_TITLE = B_TITLE || IN_VAR
WHERE B_NUM = 1;
COMMIT;
END ADD_BOARD;
/
EXEC ADD_BOARD('1');