Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: to check if a table exists

Re: to check if a table exists

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 12 Apr 2004 06:16:51 GMT
Message-ID: <nvqec.5212$ED.3499@news-server.bigpond.net.au>

"DottingTheNet" <dottingthenet_at_hotmail.com> wrote in message news:11bf8d5a.0404112139.78b6b18e_at_posting.google.com...
> i promise no more silly questions after this
>
> but how do i check if a table exists??
> it is my understanding that the exists can only be used in the where
> clause of the query.
> i just want s'thing simple like
> if exists ('test')
> then ---good
> else
> --create it
> end if;
> thanx in advance!!!

Check out the ALL_TABLES and USER_TABLES views in the "Database Reference" manual.

Douglas Hawthorne Received on Mon Apr 12 2004 - 01:16:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US