[ORACLE] oracle truncate procedure 예제

CREATE OR REPLACE PROCEDURE SP_TEST_TRUNCATE IS

    cmd    VARCHAR2(4000);

BEGIN

    cmd   := 'TRUNCATE TABLE MYDB.TEST_TABLE';

    EXECUTE IMMEDIATE cmd;

END SP_TEST_TRUNCATE ;