Re: How does SQL*Plus's DESCRIBE command work internally?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 22 Apr 2002 08:02:22 -0700
Message-ID: <aa18lu0208o@drn.newsguy.com>

In article <3cc40a77$0$271$edfadb0f_at_dspool01.news.tele.dk>, "Finn says...
>
>How does SQL*Plus's DESCRIBE command work internally? For
>tables/views/object types it's easy, but how does it determine the
>procedures/functions in a package? The source code could be parsed (but
>DESCRIBE seems too fast) and what if the source code is wrapped?
>
>Some internal (or hopefully public) data dictionary views must keep this
>information and I'm interested in accessing that information.
>
>Cheers,
>
>Finn
>
>

ALL|USER|DBA_arguments

has that.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Apr 22 2002 - 10:02:22 CDT