9.75 V$SQLFN_METADATA

V$SQLFN_METADATA contains metadata about operators and built-in functions. Note that this view does not contain information about arguments because the number of arguments will be different for various functions. Information about arguments is contained in V$SQLFN_ARG_METADATA, which can be joined with V$SQLFN_METADATA to get information about any function and its arguments.
Column Datatype Description

FUNC_ID

NUMBER

Internal function identification number

NAME

VARCHAR2(128)

Name of the built-in function

MINARGS

NUMBER

Minimum number of arguments for the function

MAXARGS

NUMBER

Maximum number of arguments for the function

DATATYPE

VARCHAR2(8)

Return data type, which can take any Oracle data type values, data type family values, or ARG[n] data types

VERSION

VARCHAR2(12)

Minimum version of the database that has this function

ANALYTIC

VARCHAR2(3)

Indicates whether the function is an analytic function (YES) or not (NO)

AGGREGATE

VARCHAR2(3)

Indicates whether the function is an aggregate function (YES) or not (NO)

OFFLOADABLE

VARCHAR2(3)

Indicates whether execution of the function can be offloaded to the Oracle Exadata Storage Server (YES) or not (NO)

See Also: Oracle Exadata Storage Server Software documentation for more information

DISP_TYPE

VARCHAR2(13)

Function display type:

  • NORMAL

  • ARITHMETIC

  • PARENTHESIS

  • REL-OP

  • CASELIKE

  • NOPARENTHESIS

USAGE

VARCHAR2(128)

A text explanation of how to use this function. The text is based on the syntax diagram for the function in the Oracle Database SQL Language Reference.

DESCR

VARCHAR2(4000)

Description of the function

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

"V$SQLFN_ARG_METADATA"