In Oracle11g, the following functions, which are based on SQL functions of the same name, were added to the OLAP DML.
BIN_TO_NUM
INSTR functions
LNNVL
MODULO (based on the SQL MOD function)
NLSSORT
REMAINDER
Additionally, the LOG function was modified so that it corresponds more exactly to its SQL counterpart.