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: Describe command equivalent query

Re: Describe command equivalent query

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 15 Jun 2004 18:16:30 -0700
Message-ID: <1087348609.660667@yasure>


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)
Received on Tue Jun 15 2004 - 20:16:30 CDT

Original text of this message

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