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

From: Sandra Jones <sfjones_at_bellsouth.net>
Date: 1997/09/09
Message-ID: <3415F817.7CDF_at_bellsouth.net>#1/1


greg teets wrote:
>
> On Wed, 27 Aug 1997 15:43:33 -0300, "Michael A. Casillas"
> <casillas_at_icepr.com> wrote:
>
> You can select against USER_TABLES
>
> Greg in Cincinnati
> >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
> >

If you know the name of the table, why not just you use
describe table_name;

if the table exist it will be described

sincerely,

fred jones Received on Tue Sep 09 1997 - 00:00:00 CEST

Original text of this message