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

Home -> Community -> Usenet -> c.d.o.server -> Re: Does a table exist

Re: Does a table exist

From: Sue Schoch <sue_at_iris.washington.edu>
Date: Thu, 10 Jan 2002 21:25:09 GMT
Message-ID: <3C3E06FE.ACCC75DB@iris.washington.edu>


Philip Morrow wrote:

> What code can I run to determine if a table say 'tablea' exists in a schema
>
> Thanks
> Phil

select table_name from dba_tables where table_name = 'TABLEA' and owner = 'SCHEMA_NAME' ;

--

Sue Schoch
mailto:sue_at_iris.washington.edu
IRIS Data Management Center
Received on Thu Jan 10 2002 - 15:25:09 CST

Original text of this message

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