System functions supported for function-based indexes

This topic lists the system functions that can be directly or conditionally used for function-based indexes.

System functions without requirements on the data type

System functions with requirements on the data type

The following system functions are prohibited in function-based indexes or generated columns when the data type is string and the default data format is used. If the time format is not the default one, there are requirements on the format parameter. For example, TO_DATE(expr, fmt) requires that the value of fmt contain the date.

JSON functions

The following functions can be used in function-based indexes.

At present, the following function can be used only in predicates.

CAST expressions

When the target or source type of a CAST expression is a time type, the CAST expression cannot be used in function-based indexes. The following table lists the detailed scenarios.