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

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

to check if a table exists

From: DottingTheNet <dottingthenet_at_hotmail.com>
Date: 11 Apr 2004 22:39:56 -0700
Message-ID: <11bf8d5a.0404112139.78b6b18e@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!!! Received on Mon Apr 12 2004 - 00:39:56 CDT

Original text of this message

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