Re: How can I access in Oracle to the system tables ?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Mar 2001 18:39:06 +0100
Message-ID: <tbn6jrggoc8k5d_at_beta-news.demon.nl>
Date: Fri, 23 Mar 2001 18:39:06 +0100
Message-ID: <tbn6jrggoc8k5d_at_beta-news.demon.nl>
"Jose Martins" <jarmartins_at_free.fr> wrote in message
news:moIu6.247$Hj1.1304723_at_nnrp6.proxad.net...
> Hi,
>
> I am trying to access in Oracle 8i to the system databases, the equivalent
> in SQL Server to tables syscomments, sysobjects etc...
>
> Does anyone know how to acced to this tables in Oracle?
> Thank a lot for your help.
> José Martins
>
> jarmartins_at_free.fr
>
>
select * from dict and the manuals tell you which dictionary tables do exist.
Regards,
Sybrand Bakker, Oracle DBA Received on Fri Mar 23 2001 - 18:39:06 CET