Re: built-in functions

I think this is pretty much what I need. Somebody else suggested another query which also seems to work fine:

select unique object_name
from all_arguments
where package_name = 'STANDARD'

However, the problem is that commonly used function "MAX" does not appear in the result produced by the query above and by the query that you have given below.

Basically, I am looking for sql statement(s) that would:

1. get the names of all built-in functions (including commonly used functions such as MAX, MIN).
2. given the name of a function, return the number and type of arguments that the function takes as input.

Seems like its a pain in oracle to get a simple list of all built-in functions along with commonly used once. And I am just looking for funtions right now, later on I need to do the same with stored procedures, user functions, and pl/sql packages.

Thanks,

• Pinto

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:<ap81ak$s81at$1_at_ID-127142.news.dfncis.de>...
> Hi,
>
> select text
> from dba_source
> where name='STANDARD'
> and text like ' function%'
> and (substr(text,12,1)<>'''' and substr(text,12,1)<>'"')
> order by 1
>
> You can add more conditions to get exactly you need. Or I didn't understand
> you correctly?
>
> Regards,
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
>
> "underground_covert_IT_operations" <pntva_at_yahoo.com> wrote in message
> news:2b5f60b4.0210231618.6dcb9f5f_at_posting.google.com...
> > Hello,
> >
> > Does oracle have a system table where all the names of built-in
> > function is stored. I need to get a list of all the built-in function
> > supported in oracle database on-the-fly and programmatically.
> >
> > Thanks,
Received on Fri Oct 25 2002 - 13:04:19 CDT