Re: Test for a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 Jan 2002 22:48:06 +0100
Message-ID: <3t5h4u8eg0eckhl9qd0e1bi1l5nh0dtmpf@4ax.com>

On Fri, 18 Jan 2002 21:23:24 GMT, "Philip Morrow" <cracker_at_mymorrow.com> wrote:

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

why would you want to do so?
In a well-designed system the table exists, and if it doesn't exist your exception handler will trap it's non-existance.
Otherwise your code is going to be completely unreadable because of the redundant tests.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jan 18 2002 - 15:48:06 CST