Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: How to check if a table exists or not?
First I can think of is to trap the ORA error (ORA-00942 table or view does
not exist) in EXCEPTION
part of a program.
> How can I check in PL/SQL if a table exists or not. Is there a built in
> function that can return TRUE or FALSE? I know the table name, I just
> want to know if it's there or if I have to create it. Thanks in
> advance.
Received on Thu Aug 28 1997 - 00:00:00 CDT