Re: How do I know if a table exists?

Oh, you want to please a user.......Well if we must...

I'm not near my docs but I think there are some thing(s) you can set in the script to suppress output to the screen..

"Robert H. Oujesky" <roujesky_at_neuralog.com> wrote:

>True, and that is what I am doing now. I just don't want users getting
>tense watching error messages scroll by. I am doing this for several tables
>and the user (Geologist, not computer literate...) is actually kicking this
>off automatically.
>
>Thanx
>
>"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
>news:qr2k9uspmdn8lomi34bms69alk0a542r53_at_4ax.com...
>>
>> Unless you really need to know, just drop it..the error about the table
>not existing will not stop your script..
>>
>>
>> "Robert H. Oujesky" <roujesky_at_neuralog.com> wrote:
>>
>> >I am running a script in SQLPlus. If the table exists, I want to drop it
>> >and then re-create it. I just don't know the syntax for checking the
>> >existance of a table....
>> >
>> >Thanx
>> >
>>
>>
>>
>> -----= 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! ==-----
>

-----= 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! ==----- Received on Thu Mar 21 2002 - 12:14:23 CST