PLSQL: how to test if a table exists?

Hello,

in a PLSQL script, I want to execute code only if a certain table exists. A pseudo-solution could be:

declare
  cursor c1 is select * from notable;
begin
  open c1;
  if c1%ISOPEN then

• statements to execute if table exists end if; end;

Obviously, the above code is not correct, first of all the script throws an execption if "notable" doesn't exist.
Any workaround?

Thank you Received on Thu Dec 04 2003 - 03:39:54 CST