Re: table/column identifiers

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Thu, 17 Jun 1999 10:28:35 +0200
Message-ID: <3768B1B3.1E12218B@si.unirioja.es>

Finnegan Calabro escribió:
> =

> Is there a way using either SQL or PHP with Oracle 8 to get all the tab=
le
> names and column names? Not the actual data in the tables, but the
> identifiers for each table and column? Thanks.
> Finn

If I understood right:

With a DBA account

select owner, table_name
 from dba_tables
 order by owner;
select owner, table_name, column_name
 from dba_tab_columns
order by owner, table_name;

• =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Thu Jun 17 1999 - 03:28:35 CDT