declare
num number;
begin
select count(1) into num from user_tables where table_name= '大写表名 ';
if num> 0 then
execute immediate 'drop table '||大写表名;
end if;
execute immediate 'create table.... ';
end;
删除表前判断
最新推荐文章于 2022-11-19 22:14:33 发布