Re: PL/SQL: How to check if a table exists or not?

Try looking at the view ALL_TABLES (where table_owner = user) or the view user_tables.

rr

Michael A. Casillas wrote:

> Yet another one:
>
> 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.
>
> Michael Casillas
Received on Mon Sep 01 1997 - 00:00:00 CDT