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: Test for a table

Re: Test for a table

From: Mark & Kristi Wagoner <mwagoner_at_iac.net>
Date: Fri, 18 Jan 2002 20:17:33 -0500
Message-ID: <a2ahfd$16kk$1@genma.iac.net> 





select count(*) from all_tables (or user_tables) where table_name='XXX';



"Philip Morrow" <cracker_at_mymorrow.com> wrote in message
news:gn028.364520$oj3.71133325_at_typhoon.tampabay.rr.com...


> How can I test for the existance of a table using a SQL statement.

>

> Thanks

> Phil

>

>

Received on Fri Jan 18 2002 - 19:17:33 CST












Original text of this message













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