Supported functions

List of detected functions from different workloads migrated in the SMA and their functional equivalence.

Strings

Function	Status
CONCAT	SUPPORTED
CONCAT_WS	SUPPORTED
LOWER	SUPPORTED
LPAD	SUPPORTED
REVERSE	SUPPORTED
SUBSTR/SUBSTRING	SUPPORTED
TRANSLATE	SUPPORTED
TRIM	SUPPORTED
UPPER	SUPPORTED

Numerics

Function	Status
ABS	SUPPORTED
AVG	SUPPORTED
COUNT	SUPPORTED
DENSE_RANK	SUPPORTED
MAX	SUPPORTED
MIN	SUPPORTED
RANK	SUPPORTED
REGEXP_REPLACE	SUPPORTED
ROUND	SUPPORTED
SUM	SUPPORTED

Date

Function	Status
ADD_MONTHS	SUPPORTED
CURRENT_DATE	SUPPORTED
CURRENT_TIMESTAMP	SUPPORTED
DATE_ADD	PENDING
DATEDIFF	PENDING
DATE_FORMAT	PENDING
FIRST_VALUE	PENDING
FROM_UNIXTIME	PENDING
LAST_DAY	SUPPORTED
MONTH	SUPPORTED
TO_DATE	SUPPORTED
TO_UTC_TIMESTAMP	PENDING
UNIX_TIMESTAMP	PENDING
YEAR	SUPPORTED

Advanced functions

Function	Status
CAST	SUPPORTED
COALESCE	SUPPORTED
COLLECT_SET	PENDING
LAG	SUPPORTED
LEAD	PENDING
NVL	SUPPORTED
NTILE	SUPPORTED
PARTITION	PENDING
ROW_NUMBER	SUPPORTED
TRUNC	PENDING