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

From: flux <flux_at_berlin.snafu.de>
Date: 1997/09/10
Message-ID: <3416A421.68491679_at_berlin.snafu.de>#1/1


Sandra Jones wrote:

> 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

  try: select object_name from obj where object_type = 'TABLE' and object_name = 'MY_TABLE_NAME'; Received on Wed Sep 10 1997 - 00:00:00 CEST

Original text of this message