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(30)`	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 datatype, which can take any Oracle datatype values, datatype family values, or ARG[n] datatypes
`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(30)`	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