select count(*) from dba_tables where table_name='...' and owner='....'
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;