Try looking for the table using the ACCESSIBLE_TABLES view.
--
Rich L
london_at_asifs.com
Dmitry Babitsky <dimitry_at_ix.netcom.com> wrote in article
<01bcba20$8e0cbad0$28ccb7c7_at_dmitry40e>...
> I need to find out in my procedure if a table exists and drop and
recreate
> it .
> This is how it's done in Transact-SQL(SQL Server):
> IF EXISTS(SELECT * FROM sysobjects where name = my_table) DROP TABLE
> my_table
> .....
> CREATE TABLE my_table
>
> Can anybody help me do it in PL/SQL? Thanks in advance and if you can -
> please e-mail your answer.
>
> --
> Dmitry Babitsky. MCSE, MCSD
>
> dimitry_at_ix.netcom.com
>
Received on Wed Sep 10 1997 - 00:00:00 CDT
