Re: PLSQL: how to test if a table exists?

Thanks to everybody.
Using your suggestions, I produced the following code:

declare

   c numeric;
begin

   select count(*) into c from user_tables where table_name = 'TABLEXY';    if c > 0 THEN

• statements to do end if; end;

Hope this could help other newbies :-)
Regards Received on Thu Dec 04 2003 - 07:58:58 CST