use procedure:
create or replace procedure create_table(table_name string)
as
v_i integer;
begin
select count(*) into v_i form tab where table_name='||table_name;
if v_i=0 then
execute immediate 'create table '||table_name||'...;
end if;
end create_table;
create or replace procedure create_table(table_name string)
as
v_i integer;
begin
select count(*) into v_i form tab where table_name='||table_name;
if v_i=0 then
execute immediate 'create table '||table_name||'...;
end if;
end create_table;
不管有没有,先删掉,在建.
drop table xxx
create ...