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_at_news-server.bigpond.net.au>
Date: Mon, 12 Apr 2004 06:16:51 GMT
Message-ID: <nvqec.5212$ED.3499_at_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 - 08:16:51 CEST