From: Sandra Jones <sfjones@bellsouth.net>
Subject: Re: PL/SQL: How to check if a table exists or not?
Date: 1997/09/09
Message-ID: <3415F817.7CDF@bellsouth.net>#1/1
References: <34047555.2D31BB02@icepr.com> <3404a6ca.71115418@news.ececs.uc.edu>
Reply-To: sfjones@bellsouth.net
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases.oracle,comp.database.oracle



greg teets wrote:
> 
> On Wed, 27 Aug 1997 15:43:33 -0300, "Michael A. Casillas"
> <casillas@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