Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe command equivalent query
SRevale wrote:
> "Bagieta" <bagieta21_at_poczta.onet.pl> wrote in message news:<caor5l$aok$1_at_news.onet.pl>...
>
>>SELECT OBJECT_NAME, OBJECT_TYPE, STATUS >> FROM SYS.ALL_OBJECTS >> WHERE OBJECT_TYPE IN ('FUNCTION', 'PROCEDURE', 'TRIGGER', >>'PACKAGE') >> AND OWNER = 'OWNER_NAME' >> >>Best regards >>Bagieta >>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >>dbDeveloper - Multiple databases editor >> >>http://prominentus.com >>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
desc <object_name>
or
SELECT object_name, argument_name, data_type, default_value, in_out
FROM all_arguments
WHERE package_name = <package_name>
ORDER BY object_name, position;
Go http://www.ca.com and order a copy of their data dictionary poster. If you can't find it there send a donation large enough to cover postage to the Puget Sound Oracle Users Group and I will send you one. http://www.psoug.org
-- 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 Wed Jun 23 2004 - 19:27:47 CDT
![]() |
![]() |