Re: Testing a table existence

Hi Sylvain!
Following works:
myVariable:=0;
select count(*) into myVariable from dba_tables where table_name='MYTABLE'; if myVariable>0 then
...
end if;

I prefer dba_tables, because so the table owner can be any user!

HTH
Peter Received on Mon Dec 10 2001 - 09:48:58 CST