WEBSITE:https://stackoverflow.com/questions/14564641/drop-a-table-in-a-procedure

Qusetion:Hou to use procedure drop a table in oracle.

Eample Syntax

CREATE OR REPLACE PROCEDURE SP_VEXISTABLA(NOMBRE IN VARCHAR2)
IS
CANTIDAD NUMBER(3);
BEGIN
SELECT COUNT(*) INTO CANTIDAD FROM USER_TABLES WHERE TABLE_NAME = NOMBRE;
IF (CANTIDAD >0) THEN
    execute immediate 'DROP TABLE ' || NOMBRE;
END IF;
END;
BEGIN
    SP_VEXISTABLA('EMP');
END;

 

posted on 2017-11-04 13:35  杨杨yang  阅读(258)  评论(0)    收藏  举报