数据源从Oracle到MySQL兼容适配

WM_CONCAT && GROUP_CONCAT

-- Oracle
select WM_CONCAT (DICT_VALUE1) from SYS_DICT t WHERE t.ROOT_KEY = 'XBDM';

-- MySQL
select GROUP_CONCAT(DICT_VALUE1) from SYS_DICT t WHERE t.ROOT_KEY = 'XBDM';

 

NVL && COALESCE

Oracle：COALESCE()、NVL()

MySQL：COALESCE()

-- COALESCE函数在MySQL跟Oracle都适用，NVL函数在Oracle中适用，COALESCE可替换NVL。

-- Oracle
SELECT NVL(SUCCESS_VISIT,0) FROM table;

-- MySQL
SELECT COALESCE(SUCCESS_VISIT,0) FROM table;

 

TO_DATE && STR_TO_DATE

-- Oracle
SELECT TO_DATE(field,'yyyy-MM-dd') from dual;
SELECT TO_DATE(field,'yyyy-MM-dd HH24:mi:ss') from dual;

-- MySQL
SELECT STR_TO_DATE(field,'%Y-%m-%d');
SELECT STR_TO_DATE(field,'%Y-%m-%d %H:%i:%s');

 

TO_CHAR && DATE_FORMAT

-- Oracle
SELECT TO_CHAR(field,