USER_LIBRARY_MANIFEST

Lists user-defined functions contained in all loaded user libraries.

Column Name Data Type Description
SCHEMA_NAME

VARCHAR

The name of the schema containing the function.

LIB_NAME

VARCHAR

The name of the library containing the UDF.

LIB_OID

INTEGER

The object ID of the library containing the function.

OBJ_NAME

VARCHAR

The name of the constructor class in the library for a function.

OBJ_TYPE

VARCHAR

The type of user defined function (scalar function, transform function)

ARG_TYPES

VARCHAR

A comma-delimited list of data types of the function's parameters.

RETURN_TYPE

VARCHAR

A comma-delimited list of data types of the function's return values.

Privileges

None