create or replace procedure PROC_dropTable(tabName in varchar2)
as
tableName user_tables.table_name%type;
mycount number(10);
begin
tableName:= tabName;
SELECT COUNT(*) INTO mycount FROM user_tables WHERE TABLE_NAME = tableName ;
if mycount>0 then
execute immediate 'DROP TABLE '||tableName;
end if;
end;
oracle删除表的存储过程
最新推荐文章于 2024-06-13 15:30:37 发布