--创建存储过程代码:
CREATE OR REPLACE PROCEDURE sp_drop_table (tabName IN VARCHAR2)
IS
num NUMERIC;
BEGIN
SELECT COUNT(*) INTO num FROM user_all_tables WHERE table_name = UPPER(tblName);
IF num > 0 THEN
EXECUTE IMMEDIATE 'DROP TABLE '||tblName;
END IF;
END;
/
--编译成功但还有警告提示不知道是哪里错误,请高手指点,谢谢!
CREATE OR REPLACE PROCEDURE sp_drop_table (tabName IN VARCHAR2)
IS
num NUMERIC;
BEGIN
SELECT COUNT(*) INTO num FROM user_all_tables WHERE table_name = UPPER(tblName);
IF num > 0 THEN
EXECUTE IMMEDIATE 'DROP TABLE '||tblName;
END IF;
END;
/
--编译成功但还有警告提示不知道是哪里错误,请高手指点,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货