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 -> print out structure of pl/sql record

print out structure of pl/sql record

From: spliffy <orastuff_at_gobh.co.uk>
Date: 20 May 2004 15:20:03 -0700
Message-ID: <7c66d42.0405201420.2b64b102@posting.google.com>


Hi,

I'd like to query the database for the definition of a user defined pl/sql record (i.e. print out the record's fields, and their type). You'd think describe would do it, but it's doesn't work with pl/sql records.
So does anyone know how to do this from sqlplus? Note, it must be done by querying the database, and not parsing text files.

Kind regards Received on Thu May 20 2004 - 17:20:03 CDT

Original text of this message

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