Re: Extracting Table Names/Field Names/Field Types?

(Pete Cresswell) wrote:
> I'm writing a metadata app and need to load a few hundred tables from an Oracle
> DB.
>
> Right now, I'm firing up MS Access and writing DAO code to loop through the ODBC
> connections. Works ok, but doesn't return the "real" Oracle field types (e.g.
> "VARCHAR (24)".
>
> Is there some syntax I can use in PL-SQL that will let return this info in a
> recordset?

Congratulations on your attempt to reinvent the wheel ... you are in excellent company no doubt.

Likely everything you are trying to do has been done by Oracle for far more than a decade and can be found in user_all_tables, user_tab_columns, user_tab_partitions, user_tab_subpartitions, and user_lob_subpartitions.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)