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