REPOST: Re: Test for a table

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 25 Jan 2002 12:14:12 -0600
Message-ID: <3$--$%%%_$_%-$_$_$@news.noc.cabal.int>

If the table is large that could take a long time; Try:

select 'x' from table_name where 1=1 and rownum < 2;

If it does exist, x will be returned..
If the table does not exist, an error will result ( an ORA 942)... ( same as would happen in the other response)

"Mark & Kristi Wagoner" <mwagoner_at_iac.net> wrote:

>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
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----

WAS CANCELLED BY =======: From: TurkBear <jgreco1_at_mn.rr.com> Control: cancel <ln735u0u115fcp42evtam2qe1q9eiacj4b_at_4ax.com> Subject: cmsg cancel <ln735u0u115fcp42evtam2qe1q9eiacj4b_at_4ax.com> Date: Mon, 28 Jan 2002 02:31:52 GMT Message-ID: <cancel.ln735u0u115fcp42evtam2qe1q9eiacj4b_at_4ax.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!freenix!wanadoo.fr!opentransit.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722551

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 12:14:12 CST