PL/SQL Functions

OLAP DML Functions

The OLAP functions are standard text and calculation functions that initiate actions and returns different values.

The OLAP DML provides the typical numeric and text functions:

Conversion, Datetime, Date-only, Financial, File management, NA (NULL), Numeric, Numeric aggregation, Statistical and forecasting, Text, Analytic workspace and object information, Aggregation, allocation, and model specification, System and Database information, Time-series functions.

AvgChrCoalesceConcat
CountDecodeExtractInstr
LengthLpadLtrimMax
MinModNvlNvl2
ReplaceRoundRpadRtrim
SubstrSumTranslateTrim
TruncTo_charTo_dateTo_number
Dense_RankRankListaggSys_Connect_By_Path