declare
i integer;
begin
select count(*) into i from user_tables where table_name='ANYNAME';
if i>0 then
dbms_output.put_line('该表已存在!');
execute immediate 'drop table anyname';
else
dbms_output.put_line('该表不存在');
end if;
execute immediate 'create table anyname(id varchar(20) primary key,name varchar(50))';
end;
begin
select count(*) into i from user_tables where table_name='ANYNAME';
if i>0 then
dbms_output.put_line('该表已存在!');
execute immediate 'drop table anyname';
else
dbms_output.put_line('该表不存在');
end if;
execute immediate 'create table anyname(id varchar(20) primary key,name varchar(50))';
end;
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;