declarecreate or replace procedure ExistTable(tabname varchar2) is
cursor c_tablename is select table_name from user_tables;
flag number(1);
begin
flag:=0;
for r_tablename in c_tablename loop
if r_tablename.table_name=tabname then
flag:=1;
end if;
end loop;
if flag=1 then
--insert
else
dbms_output.put_line('the table is exist!');
end if;
end ExistTable;
cursor c_tablename is select table_name from user_tables;
flag number(1);
begin
flag:=0;
for r_tablename in c_tablename loop
if r_tablename.table_name=tabname then
flag:=1;
end if;
end loop;
if flag=1 then
--insert
else
dbms_output.put_line('the table is exist!');
end if;
end ExistTable;
如果结果等于1存在 0不存在