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 AI 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”