다른 명령
CREATE OR REPLACE PROCEDURE SP_DROP_TAB(pOwner in varchar2,pTable in varchar2) IS CHK_TAB INTEGER := 0; BEGIN SELECT 1 INTO CHK_TAB FROM ALL_TABLES WHERE OWNER IN (pOwner) AND TABLE_NAME = pTable AND ROWNUM <= 1 ; IF CHK_TAB > 0 THEN EXECUTE IMMEDIATE 'DROP TABLE '||pOwner||'.'||pTable||' CASCADE CONSTRAINTS'; END IF ; COMMIT; --EXCEPTION -- WHEN OTHERS THEN -- RAISE USER_SEQL_EXCEPTION; END; /