Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Extracting Table Names/Field Names/Field Types?

Extracting Table Names/Field Names/Field Types?

From: Pete Cresswell <x_at_y.z>
Date: Sun, 25 Jan 2004 02:39:04 GMT
Message-ID: <e2b610tpg7e52qofgg7sho42idkpkre3nu@4ax.com>


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?

-- 
PeteCresswell
Received on Sat Jan 24 2004 - 20:39:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US