Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does a table exist
"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