Re: Selecting from Oracle Internal Tables

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 29 Oct 1998 23:16:41 GMT
Message-ID: <3638f003.2343552@news.siol.net>

On Thu, 29 Oct 1998 08:47:32 GMT, segoro_at_my-dejanews.com wrote:

>Hi everybody!
>WHO Knows how can I obtain
>list of ORacle internal TAbles with Columns and maybe Descriptions.
>I mean Tables with name like 'X$%'
>FOr example x$kgllk, x$kglpn and so on.

For a list of fixed tables/views look at V$FIXED_TABLE. For a list of columns of each you'll have to do DESCRIBE on each one of them. For a detailed description of this tables and their columns- well, I can't offer you to much help on this one....

>Thanks in advance!
>Segoro.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Oct 29 1998 - 17:16:41 CST