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');