Re: Programatic access to schema data

Bill Prew wrote:
> I have a need to write a program (PL/SQL) that can read and work with
> data in the meta data tables that define the schema in an Oracle
> database. Can someone(s) point me in the right direction here, I would
> need info on where all the meta data is described, how I access it
> programatically, and some sample code would be a huge help.
>
> For a given application table,

dba_tables

I want to be able to enumerate all the
> fields

dba_tab_columns

and referential constraints

dba_constraints

defined for that table, and then
> chase some of those referential contraints to locate "dependant"
> records in other tables.
>

Reference guides a tahiti.oracle.com Received on Thu Jan 02 2003 - 21:01:26 CET