Re: PLSQL: how to test if a table exists?

On Thu, 4 Dec 2003 14:58:58 +0100, "NoName" <nobody_at_nowhere.com> wrote:

>Thanks to everybody.
>Using your suggestions, I produced the following code:
>
>declare
> c numeric;
>begin
> select count(*) into c from user_tables where table_name = 'TABLEXY';
> if c > 0 THEN
> -- statements to do
> end if;
>end;
>
>Hope this could help other newbies :-)
>Regards
>

They would better trust appropiate exception handling and not trust this horrible approach.

--
Sybrand Bakker, Senior Oracle DBA