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

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

Re: Does a table exist

From: Palaksha <palakshak_at_balwase-com.com>
Date: 10 Jan 2002 22:05:13 -0800
Message-ID: <5c8eee74.0201102205.3275bf3@posting.google.com>


"Philip Morrow" <cracker_at_mymorrow.com> wrote in message news:<UYm%7.294760$oj3.58440709_at_typhoon.tampabay.rr.com>...
> What code can I run to determine if a table say 'tablea' exists in a schema
>
> Thanks
> Phil

select select count(*) from tabs where table_name='TABLEA' Received on Fri Jan 11 2002 - 00:05:13 CST

Original text of this message

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