Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: getting list of built-in function from system catalog

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

From: underground_covert_IT_operations <pntva_at_yahoo.com>
Date: 23 Oct 2002 17:27:21 -0700
Message-ID: <2b5f60b4.0210231627.4b25e1c3@posting.google.com>


By built-in functions, I mean functions that are implemented natively in oracle such as MAX, MIN, CONCAT, etc. Is there a system catalog that describes these functions.

Thanks

kenneth.koenraadt_at_no-spam.hotmail.com wrote in message news:<3db67a42.1352604_at_news.mobilixnet.dk>...
> Hi,
>
> What exactly do you mean by "built-in functions" ?
>
> There are SQL functions (AVG, SUBSTR etc). Oracle 9i contains all
> ANSI-99 SQL functions and more too.
>
> There are PL/SQL supplied packages and JAVA classes. They can be
> retrieved by this query :
>
> select * from dba_objects
> where object_type in ('FUNCTION','PROCEDURE','PACKAGE','JAVA CLASS');
>
>
> Instead, I will suggest you take a look in the on-line doc under
>
> "Application Development"->
>
> "Oracle9i Supplied Java Packages Reference"
> and
> "Oracle9i Supplied PL/SQL Packages and Types Reference"
>
> Which covers them all nicely.
>
>
> - Kenneth Koenraadt
>
>
> On 22 Oct 2002 12:31:04 -0700, pntva_at_yahoo.com
> (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 Wed Oct 23 2002 - 19:27:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US