| Function Name |
Analytic |
Collection |
Conversion |
Date &
Timestamp |
Data Mining |
Misc. |
Model
Clause |
Null
Handling |
Numeric |
Object |
String |
XML |
| ABS |
|
|
|
|
|
|
|
|
 |
|
|
|
| ACOS |
|
|
|
|
|
|
|
|
|
|
|
|
| ADD_MONTHS |
|
|
|
 |
|
|
|
|
|
|
|
|
| ADJ_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
| APPENDCHILDXML |
|
|
|
|
|
|
|
|
|
|
|
 |
| ASCII |
|
|
|
|
|
|
|
|
|
|
 |
|
| ASCIISTR |
|
|
|
|
|
|
|
|
|
|
|
|
| ASIN |
|
|
|
|
|
|
|
|
|
|
|
|
| ATAN |
|
|
|
|
|
|
|
|
|
|
|
|
| ATAN2 |
|
|
|
|
|
|
|
|
|
|
|
|
| AVG |
 |
|
|
|
|
|
|
|
|
|
|
|
| BFILENAME |
|
|
|
|
|
|
|
|
|
|
|
|
| BIN_TO_NUM |
|
|
|
|
|
|
|
|
|
|
|
|
| BINARY2VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| BIT_COMPLEMENT |
|
|
|
|
|
|
|
|
|
|
|
|
| BIT_OR |
|
|
|
|
|
|
|
|
|
|
|
|
| BIT_XOR |
|
|
|
|
|
|
|
|
|
|
|
|
| BITAND |
|
|
|
|
|
|
|
|
|
|
|
|
| BOOL_TO_INT |
|
|
|
|
|
|
|
|
|
|
|
|
| CARDINALITY |
|
 |
|
|
|
|
|
|
|
|
|
|
| CASE |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_FROM_BINARY_DOUBLE |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_FROM_BINARY_FLOAT |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_FROM_BINARY_INTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_FROM_NUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_BINARY_DOUBLE |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_BINARY_FLOAT |
|
|
|
|
|
|
|
|
|
|
|
|
CAST_TO_BINARY
_INTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_NUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_NVARCHAR2 |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_RAW |
|
|
|
|
|
|
|
|
|
|
|
|
| CAST_TO_VARCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| CEIL |
|
|
|
|
|
|
|
|
|
|
|
|
| CHARTOROWID |
|
|
|
|
|
|
|
|
|
|
|
|
| CHR |
|
|
|
|
|
|
|
|
|
|
|
|
| CLASSIFIER (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| CLUSTER_DETAILS (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| CLUSTER_DISTANCE (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| CLUSTER_ID |
|
|
|
|
|
|
|
|
|
|
|
|
| CLUSTER_PROBABILITY |
|
|
|
|
|
|
|
|
|
|
|
|
| CLUSTER_SET |
|
|
|
|
|
|
|
|
|
|
|
|
| COALESCE |
|
|
|
|
|
|
|
|
|
|
|
|
| COLLECT |
|
|
|
|
|
|
|
|
|
|
|
|
| COMPOSE |
|
|
|
|
|
|
|
|
|
|
|
|
| CONCAT |
|
|
|
|
|
|
|
|
|
|
|
|
| CONVERT |
|
|
|
|
|
|
|
|
|
|
|
|
| CORR |
|
|
|
|
|
|
|
|
|
|
|
|
| CORR_K |
|
|
|
|
|
|
|
|
|
|
|
|
| CORR_S |
|
|
|
|
|
|
|
|
|
|
|
|
| COS |
|
|
|
|
|
|
|
|
|
|
|
|
| COSH |
|
|
|
|
|
|
|
|
|
|
|
|
| COUNT |
|
|
|
|
|
|
|
|
|
|
|
|
| COVAR_POP |
|
|
|
|
|
|
|
|
|
|
|
|
| COVAR_SAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| CUBE_TABLE |
|
|
|
|
|
|
|
|
|
|
|
|
| CUME_DIST |
|
|
|
|
|
|
|
|
|
|
|
|
| CURRENT_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
| CURRENT_TIMESTAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| CV |
|
|
|
|
|
|
|
|
|
|
|
|
| DATAOBJ_TO_PARTITION |
|
|
|
|
|
|
|
|
|
|
|
|
| DBTIMEZONE |
|
|
|
|
|
|
|
|
|
|
|
|
| DECODE |
|
|
|
|
|
|
|
|
|
|
|
|
| DECOMPOSE |
|
|
|
|
|
|
|
|
|
|
|
|
| DELETEXML |
|
|
|
|
|
|
|
|
|
|
|
|
| DENSE_RANK |
|
|
|
|
|
|
|
|
|
|
|
|
| DEPTH |
|
|
|
|
|
|
|
|
|
|
|
|
| DEREF |
|
|
|
|
|
|
|
|
|
|
|
|
| DUMP |
|
|
|
|
|
|
|
|
|
|
|
|
| EMPTY_BLOB(large object) |
|
|
|
|
|
|
|
|
|
|
|
|
| EMPTY_CLOB (large object) |
|
|
|
|
|
|
|
|
|
|
|
|
| ENCODE_SQL_XML (UTL_I18N) |
|
|
|
|
|
|
|
|
|
|
|
|
| ESCAPE_REFERENCE |
|
|
|
|
|
|
|
|
|
|
|
|
| ESTIMATE_CPU_UNITS |
|
|
|
|
|
|
|
|
|
|
|
|
| EXISTSNODE |
|
|
|
|
|
|
|
|
|
|
|
|
| EXP |
|
|
|
|
|
|
|
|
|
|
|
|
| EXTRACT |
|
|
|
|
|
|
|
|
|
|
|
|
| EXTRACTVALUE |
|
|
|
|
|
|
|
|
|
|
|
|
| FEATURE_ID |
|
|
|
|
|
|
|
|
|
|
|
|
| FEATURE_SET |
|
|
|
|
|
|
|
|
|
|
|
|
| FEATURE_VALUE |
|
|
|
|
|
|
|
|
|
|
|
|
| FIRST |
|
|
|
|
|
|
|
|
|
|
|
|
| FIRST_VALUE |
|
|
|
|
|
|
|
|
|
|
|
|
| FLOOR |
|
|
|
|
|
|
|
|
|
|
|
|
| FROM_TZ |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_CLOCK_TIME |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_DDL |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_DEPENDENT_DDL |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_DEPENDENT_XML |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_GRANTED_DDL |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_GRANTED_XDL |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_HASH |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_REBUILD_COMMAND |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_SCN |
|
|
|
|
|
|
|
|
|
|
|
|
| GET_XML |
|
|
|
|
|
|
|
|
|
|
|
|
| GREATEST |
|
|
|
|
|
|
|
|
|
|
|
|
| GROUP_ID |
|
|
|
|
|
|
|
|
|
|
|
|
| GROUPING |
|
|
|
|
|
|
|
|
|
|
|
|
| GROUPING_ID |
|
|
|
|
|
|
|
|
|
|
|
|
| HEXTORAW |
|
|
|
|
|
|
|
|
|
|
|
|
| HEXTOREF |
|
|
|
|
|
|
|
|
|
|
|
|
| INITCAP |
|
|
|
|
|
|
|
|
|
|
|
|
| INSERTCHILDXML |
|
|
|
|
|
|
|
|
|
|
|
|
| INSERTXMLBEFORE |
|
|
|
|
|
|
|
|
|
|
|
|
| INSTR |
|
|
|
|
|
|
|
|
|
|
|
|
| INSTRB |
|
|
|
|
|
|
|
|
|
|
|
|
| INSTRC |
|
|
|
|
|
|
|
|
|
|
|
|
| INSTR2 |
|
|
|
|
|
|
|
|
|
|
|
|
| INSTR4 |
|
|
|
|
|
|
|
|
|
|
|
|
| INT_TO_BOOL |
|
|
|
|
|
|
|
|
|
|
|
|
| INTERVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| IS_BIT_SET |
|
|
|
|
|
|
|
|
|
|
|
|
| ITERATE |
|
|
|
|
|
|
| |
|
|
|
|
| ITERATE UNTIL |
|
|
|
|
|
|
|
|
|
|
|
|
| ITERATION_NUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| LAG |
|
|
|
|
|
|
|
|
|
|
|
|
| LAST |
|
|
|
|
|
|
|
|
|
|
|
|
| LAST_DAY |
|
|
|
|
|
|
|
|
|
|
|
|
| LAST_VALUE |
|
|
|
|
|
|
|
|
|
|
|
|
| LEAD |
|
|
|
|
|
|
|
|
|
|
|
|
| LEAST |
|
|
|
|
|
|
|
|
|
|
|
|
| LENGTH |
|
|
|
|
|
|
|
|
|
|
|
|
| LENGTHB |
|
|
|
|
|
|
|
|
|
|
|
|
| LENGTHC |
|
|
|
|
|
|
|
|
|
|
|
|
| LENGTH2 |
|
|
|
|
|
|
|
|
|
|
|
|
| LENGTH4 |
|
|
|
|
|
|
|
|
|
|
|
|
| LISTAGG |
|
|
|
|
|
|
|
|
|
|
|
|
| LN |
|
|
|
|
|
|
|
|
|
|
|
|
| LNNVL |
|
|
|
|
|
|
|
|
|
|
|
|
| LOCALTIMESTAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| LOG |
|
|
|
|
|
|
|
|
|
|
|
|
| LOWER |
|
|
|
|
|
|
|
|
|
|
|
|
| LPAD |
|
|
|
|
|
|
|
|
|
|
|
|
| LTRIM |
|
|
|
|
|
|
|
|
|
|
|
|
| MAKE_REF |
|
|
|
|
|
|
|
|
|
|
|
|
| MAX |
|
|
|
|
|
|
|
|
|
|
|
|
| MEDIAN |
|
|
|
|
|
|
|
|
|
|
|
|
| MIN |
|
|
|
|
|
|
|
|
|
|
|
|
| MOD |
|
|
|
|
|
|
|
|
|
|
|
|
| MONTHS_BETWEEN |
|
|
|
|
|
|
|
|
|
|
|
|
| NANVL |
|
|
|
|
|
|
|
|
|
|
|
|
| NCHR |
|
|
|
|
|
|
|
|
|
|
|
|
| NEW_TIME |
|
|
|
|
|
|
|
|
|
|
|
|
| NEXT_DAY |
|
|
|
|
|
|
|
|
|
|
|
|
| NHEXTORAW |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_CHARSET_DECL_LEN |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_CHARSET_ID |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_CHARSET_NAME |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_INITCAP |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_LOWER |
|
|
|
|
|
|
|
|
|
|
|
|
| NLSSORT |
|
|
|
|
|
|
|
|
|
|
|
|
| NLS_UPPER |
|
|
|
|
|
|
|
|
|
|
|
|
| NTH_VALUE |
|
|
|
|
|
|
|
|
|
|
|
|
| NTILE |
|
|
|
|
|
|
|
|
|
|
|
|
| NULLFN |
|
|
|
|
|
|
|
|
|
|
|
|
| NULLIF |
|
|
|
|
|
|
|
|
|
|
|
|
| NUMTODSINTERVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| NUMTOHEX |
|
|
&
|
|
|
|
|
|
|
|
|
|
| NUMTOHEX2 |
|
|
|
|
|
|
|
|
|
|
|
|
| NUMTOYMINTERVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| NVL |
|
|
|
|
|
|
|
|
|
|
|
|
| NVL2 |
|
|
|
|
|
|
|
|
|
|
|
|
| OBJECT2XML |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_CONDITION |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_EXPRESSION |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_EXPRESSION_BOOL |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_EXPRESSION_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_EXPRESSION_TEXT |
|
|
|
|
|
|
|
|
|
|
|
|
| OLAP_TABLE |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_DST_AFFECTED (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_DST_CONVERT (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_DST_ERROR (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_HASH |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_INVOKING_USER (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| ORA_INVOKING_USERID (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| PATH |
|
|
|
|
|
|
|
|
|
|
|
|
| PERCENT_RANK |
|
|
|
|
|
|
|
|
|
|
|
|
| PERCENTILE_CONT |
|
|
|
|
|
|
|
|
|
|
|
|
| PERCENTILE_DISC |
|
|
|
|
|
|
|
|
|
|
|
|
| POWER |
|
|
|
|
|
|
|
|
|
|
|
|
| POWERMULTISET |
|
|
|
|
|
|
|
|
|
|
|
|
| POWERMULTISET_BY_CARDINALITY |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION_BOUNDS |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION_COST |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION_DETAILS |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION_PROBABILITY |
|
|
|
|
|
|
|
|
|
|
|
|
| PREDICTION_SET |
|
|
|
|
|
|
|
|
|
|
|
|
| PRESENTNNV |
|
|
|
|
|
|
|
|
|
|
|
|
| PRESENTV |
|
|
|
|
|
|
|
|
|
|
|
|
| PREVIOUS |
|
|
|
|
|
|
|
|
|
|
|
|
| QUOTE DELIMITERS |
|
|
|
|
|
|
|
|
|
|
|
|
| RANDOMBYTES |
|
|
|
|
|
|
|
|
|
|
|
|
| RANDOMINTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
| RANDOMNUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| RANK |
|
|
|
|
|
|
|
|
|
|
|
|
| RATIO_TO_REPORT |
|
|
|
|
|
|
|
|
|
|
|
|
| RAW_TO_CHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| RAW_TO_NCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| RAW_TO_VARCHAR2 |
|
|
|
|
|
|
|
|
|
|
|
|
| RAWTOHEX |
|
|
|
|
|
|
|
|
|
|
|
|
| RAWTONHEX |
|
|
|
|
|
|
|
|
|
|
|
|
| RAWTONUM |
|
|
|
|
|
|
|
|
|
|
|
|
| RAWTONUM2 |
|
|
|
|
|
|
|
|
|
|
|
|
| REF |
|
|
|
|
|
|
|
|
|
|
|
|
| REFTOHEX |
|
|
|
|
|
|
|
|
|
|
|
|
| REGEXP_COUNT |
|
|
|
|
|
|
|
|
|
|
|
|
| REGEXP_INSTR |
|
|
|
|
|
|
|
|
|
|
|
|
| REGEXP_REPLACE |
|
|
|
|
|
|
|
|
|
|
|
|
| REGEXP_SUBSTR |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_AVGX |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_AVGY |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_COUNT |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_INTERCEPT |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_R2 |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_SLOPE |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_SXX |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_SXY |
|
|
|
|
|
|
|
|
|
|
|
|
| REGR_SYY |
|
|
|
|
|
|
|
|
|
|
|
|
| REMAINDER |
|
|
|
|
|
|
|
|
|
|
|
|
| REPLACE |
|
|
|
|
|
|
|
|
|
|
|
|
| REVERSE |
|
|
|
|
|
|
|
|
|
|
|
|
| ROUND |
|
|
|
|
|
|
|
|
|
|
|
|
| ROW_NUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| ROWIDTOCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| ROWIDTONCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| RPAD |
|
|
|
|
|
|
|
|
|
|
|
|
| RTRIM |
|
|
|
|
|
|
|
|
|
|
|
|
| SCN_TO_TIMESTAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| SEC2DISPLAYTIME |
|
|
|
|
|
|
|
|
|
|
|
|
| SESSIONTIMEZONE |
|
|
|
|
|
|
|
|
|
|
|
|
| SET |
|
|
|
|
|
|
|
|
|
|
|
|
| SIGN |
|
|
|
|
|
|
|
|
|
|
|
|
| SIN |
|
|
|
|
|
|
|
|
|
|
|
|
| SINH |
|
|
|
|
|
|
|
|
|
|
|
|
| SOUNDEX |
|
|
|
|
|
|
|
|
|
|
|
|
| SQRT |
|
|
|
|
|
|
|
|
|
|
|
|
| SQLCODE (exception) |
|
|
|
|
|
|
|
|
|
|
|
|
| SQLERRM (exception) |
|
|
|
|
|
|
|
|
|
|
|
|
| STANDARD_HASH (new 12c) |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_BINOMIAL_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_CROSSTAB |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_F_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_KS_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_MODE |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_MW_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_ONE_WAY_ANOVA |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_T_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_T_TEST_INDEP |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_T_TEST_INDEPU |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_T_TEST_ONE |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_T_TEST_PAIRED |
|
|
|
|
|
|
|
|
|
|
|
|
| STATS_WSR_TEST |
|
|
|
|
|
|
|
|
|
|
|
|
| STDDEV |
|
|
|
|
|
|
|
|
|
|
|
|
| STDDEV_POP |
|
|
|
|
|
|
|
|
|
|
|
|
| STDDEV_SAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| STRING_TO_RAW |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBMULTISET |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBSTR |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBSTRB |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBSTRC |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBSTR2 |
|
|
|
|
|
|
|
|
|
|
|
|
| SUBSTR4 |
|
|
|
|
|
|
|
|
|
|
|
|
| SUM |
|
|
|
|
|
|
|
|
|
|
|
|
| SYSDATE |
|
|
|
|
|
|
|
|
|
|
|
|
| SYSTIMESTAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_AT_TIME_ZONE |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_CONNECT_BY_PATH (hierarchical) |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_CONTEXT (environment) |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_DBURIGEN |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_EXTRACT_UTC |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_GUID (identifier) |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_COMBINED_HASH |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_DESCEND |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_DISTINCT |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_GUID |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_LBID |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_MAP_NONNULL |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_NUMTORAW |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_OPNSIZE |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_RAWTONUM |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_RPB |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_OP_TOSETID |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_TYPEID |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_XMLAGG |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_XMLGEN |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_XQCODEPEQ |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS_XQENDSWITH |
|
|
|
|
|
|
|
|
|
|
|
|
| SYS$RAWTOANY |
|
|
|
|
|
|
|
|
|
|
|
|
| TABLE
|
|
|
|
|
|
|
|
|
|
|
|
|
| TAN |
|
|
|
|
|
|
|
|
|
|
|
|
| TANH |
|
|
|
|
|
|
|
|
|
|
|
|
| TIMESTAMP_TO_SCN |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_BINARYDOUBLE |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_BINARYFLOAT |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_BLOB |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_CHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_CLOB |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_DATE |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_DSINTERVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_LOB |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_MULTI_BYTE |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_NCHAR |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_NCLOB |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_NUMBER |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_RAW |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_SINGLE_BYTE |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_TIMESTAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_TIMESTAMP_TZ |
|
|
|
|
|
|
|
|
|
|
|
|
| TO_YMINTERVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| TRANSLATE |
|
|
|
|
|
|
|
|
|
|
|
|
| TRANSLATE USING |
|
|
|
|
|
|
|
|
|
|
|
|
| TRANSLITERATE |
|
|
|
|
|
|
|
|
|
|
|
|
| TREAT |
|
|
|
|
|
|
|
|
|
|
|
|
| TRIM |
|
|
|
|
|
|
|
|
|
|
|
|
| TRUNC |
|
|
|
|
|
|
|
|
|
|
|
|
| TZ_OFFSET |
|
|
|
|
|
|
|
|
|
|
|
|
| UID (environment) |
|
|
|
|
|
|
|
|
|
|
|
|
| UNISTR |
|
|
|
|
|
|
|
|
|
|
|
|
| UPDATEXML |
|
|
|
|
|
|
|
|
|
|
|
|
| UPPER |
|
|
|
|
|
|
|
|
|
|
|
|
| USER (environment) |
|
|
|
|
|
|
|
|
|
|
|
|
| USERENV (environment) |
|
|
|
|
|
|
|
|
|
|
|
|
| VALUE (object) |
|
|
|
|
|
|
|
|
|
|
|
|
| VAR_POP |
|
|
|
|
|
|
|
|
|
|
|
|
| VAR_SAMP |
|
|
|
|
|
|
|
|
|
|
|
|
| VARIANCE |
|
|
|
|
|
|
|
|
|
|
|
|
| VERIFY_OWNER |
|
|
|
|
|
|
|
|
|
|
|
|
| VERIFY_TABLE |
|
|
|
|
|
|
|
|
|
|
|
|
| VERTICAL BARS |
|
|
|
|
|
|
|
|
|
|
|
|
| VSIZE |
|
|
|
|
|
|
|
|
|
|
|
|
| WIDTH_BUCKET |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_CONCAT |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_CONTAINS |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_CONTAINS |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_EQUALS |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_GREATERTHAN |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_INTERSECTION |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_LDIFF |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_LESSTHAN |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_MEETS |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_OVERLAPS |
|
|
|
|
|
|
|
|
|
|
|
|
| WM_RDIFF |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLAGG |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLCAST |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLCDATA |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLCOLLATVAL |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLCOMMENT |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLCONCAT |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLDIFF |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLELEMENT |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLEXISTS |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLFOREST |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLISVALID |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLPARSE |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLPATCH |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLPI |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLQUERY |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLROOT |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLSEQUENCE (deprecated) |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLSERIALIZE |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLTABLE |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLTRANSFORM |
|
|
|
|
|
|
|
|
|
|
|
|
| XMLTYPE |
|
|
|
|
|
|
|
|
|
|
|
|
| XOR |
|
|
|
|
|
|
|
|
|
|
|
|
