Re: PL/SQL: How to check if a table exists or not?
From: Ron Reidy <rreidy_at_ecentral.com>
Date: 1997/09/01
Message-ID: <340AE1FC.7112C9AC_at_ecentral.com>#1/1
Date: 1997/09/01
Message-ID: <340AE1FC.7112C9AC_at_ecentral.com>#1/1
Try looking at the view ALL_TABLES (where table_owner = user) or the
view user_tables.
rr
> 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 CEST