Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> print out structure of pl/sql record
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
![]() |
![]() |