Re: Oracle : IF Exists

From: Mike Dwyer <dwyermj_at_co>
Date: Tue, 17 Oct 2000 08:13:21 -0600
Message-ID: <EdZG5.109$L32.45184@wdc-read-01.qwest.net>

if exists (select 1 from all_tables where table_name = 'YOUR_TABLE') (if "you" are not the owner of the table, you would also need to include "and owner = 'OWNER_NAME'")

<holth_at_my-deja.com> wrote in message news:8sguce$10f$1_at_nnrp1.deja.com...
> Hi
> I Need some way to confirm if a table exists or not.
> In MS SQL i used the function IF EXISTS. What is the equivalent to this
> in Oracle??
> Thanks for any help
> Lars
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 17 2000 - 09:13:21 CDT