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

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 - 05:37:21 CDT