Re: How to retrieve function metadata?

Rauf Sarwar wrote:

>Originally posted by Ashwin K Gudidevuni
>
>
>
>>Hi,
>>
>>
>
>
>
>
>
>
>>I wanted to know, how to retrieve information about the functions.
>>
>>
>
>
>
>>Information like functions return type, its parameters and data
>>type of its
>>
>>
>
>
>
>>parameters, If its and aggregate function or not. If it belongs to any
>>
>>
>
>
>
>>category of functions. Is there any schema defined to retrieve
>>these values
>>
>>
>
>
>
>>like Information_Schema.Parameters in Sql Server. If someone can
>>help me by
>>
>>
>
>
>
>>pointing to the right source...
>>
>>
>
>
>
>
>
>
>>Thank you in advance.
>>
>>
>
>
>
>>Ashwin.
>>
>>
>
>
>
>Look at data dictionary view called all_arguments e.g.
>
>
>
>select *
>
>from sys.all_arguments
>
>where owner = 'Object owner'
>
>and object_name = 'Function name';
>
>
>
>Regards
>
>/Rauf Sarwar
>
>
>--
>Posted via http://dbforums.com
>
>

Also make yourself aware of the built-in package DBMS_METADATA though I think all_arguments is more what you are asking about.

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