Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: print out structure of pl/sql record
spliffy wrote:
> 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
If I had a clue what you mean by "a user defined pl/sql record" because users don't, and can't, define PL/SQL records.
Can you better explain what you mean?
-- 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)Received on Thu May 20 2004 - 18:15:32 CDT
![]() |
![]() |