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.

Avg Chr Coalesce Concat
Count Decode Extract Instr
Length Lpad Ltrim Max
Min Mod Nvl Nvl2
Replace Round Rpad Rtrim
Substr Sum Translate Trim
Trunc To_char To_date To_number
Dense_Rank Rank Listagg Sys_Connect_By_Path