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 -> Re: How does SQL*Plus's DESCRIBE command work internally?

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

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Mon, 22 Apr 2002 15:32:51 GMT
Message-ID: <3CC42D15.7F0903F4@exesolutions.com>


Take a look at the data dictionary views xxx_arguments.

I'm not sure if that is where DESCRIBE is going ... but it certainly could.

Daniel Morgan

Finn Ellebaek Nielsen wrote:

> 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
Received on Mon Apr 22 2002 - 10:32:51 CDT

Original text of this message

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