Re: getting list of built-in function from system catalog

Hi,

Just noticed that the list of functions produced by the query below does not include some common functions such as MAX, SUM, etc. Am I missing something? My program needs to have the ability to programatically get a list of buit-in functions on the fly from oracle and then get the number and type of argument given a name of a built-in function.

Any help is appreciated.

pntva_at_yahoo.com (underground_covert_IT_operations) wrote in message news:<2b5f60b4.0210231632.61bc5883_at_posting.google.com>...
> Ok this works, thanks.
>
> Richard Kuhler <noone_at_nowhere.com> wrote in message news:<Q8it9.197893$U7.53140973_at_twister.socal.rr.com>...
> > Here's one thought ...
> >
> > select distinct object_name
> > from all_arguments
> > where package_name = 'STANDARD'
> >
> >
> > Richard
> >
> > underground_covert_IT_operations wrote:
> > >
> > > I am writing an application program using JDBC and I need to get a
> > > list of built-in functions in oracle. Can this be done by querying the
> > > system catalog or any other way? What query do I run?
Received on Thu Oct 24 2002 - 20:09:15 CDT