meta-data

   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 - 19:45:59 CST