However you need dba privs to query this view and would want to specify the
owner of the table.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Peter Lintner" <peter.lintner_at_sos-kd.org> wrote in message
news:IP4R7.28$zy5.898_at_psinet-eu-nl...
> Hi Sylvain!
> Following works:
> myVariable:=0;
> select count(*) into myVariable from dba_tables where
table_name='MYTABLE';
> if myVariable>0 then
> ...
> end if;
>
> I prefer dba_tables, because so the table owner can be any user!
>
> HTH
> Peter
>
>
>
Received on Tue Dec 11 2001 - 05:41:19 CST
