Re: Describe command equivalent query

SRevale wrote:

> Hi, everybody !!
>
> I've been trying to reproduce in a query(s) the efect of the DESCRIBE
> COMMAND in the SQL-Plus.
>
> Everything seems ok until I try to describe packages. XXX_ARGUMENTS
> seems to be the solution but then I found that PROCEDURES without
> arguments didn't appear here. I also found that there is no
> object_type definition in here so, to identify if it was a FN or a SP
> I'd check for a 0 (zero) in the POSITION field).
>
> I'd also check in the SYS.OBJ$ and SYS.ARG$ tables, but it made no
> difference.
>
> So I asked then, how does DESCRIBE COMMAND really works? Is there any
> way, with one (or more) query(s), to retrieve this data?
>
>
> Thanks you all !
> Santiago

SELECT DISTINCT object_name, object_type FROM user_objects;

Then outer join to user_arguments.

-- 
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)