You can use the Dictionary table in oracle to get to know all about the
meta data.
on sql prompt:
set pause on;
select * from dictionary;
Gives Two columns
1)Table Name
2)Comments - explaining the meta data held by the table.
Do a desc on the table name to get the column names.
Use this in a select statement to get the info you want.
John McManus <mcmanus_at_pop.dn.net> wrote in article
<36e71e0f.2544610_at_news2.dn.net>...
> Given the ability to interact with an Oracle 7 server, is there a
> 'stored procedure' of some kind to gain information like lists of
> databases, tables, column-headings, column data-types, and so on? eg,
> on connecting I'd like to get a list of all databases available to the
> user. Or, given a database.table, I'd like to know what columns are in
> the table and what their data-types are.
> I do these things on a Sybase server, but I use the stored
> procedures they provide so it's all transparent to me--I don't know
> how they do it!! (: On reflection, it probably wouldn't help if i
> did, anyway.
>
> Thanks for any assistance with this.
>
> John McManus
>
Received on Wed Mar 10 1999 - 22:35:29 CST
