Re: How to retrieve function metadata?

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