1.ORACLE:
SELECT (''''||(REPLACE('公假,相亲,临时事假,打卡异常',',',''''||','||''''))||'''') FROM DUAL;
2.MYSQL:
SELECT (CONCAT('''',(REPLACE('公假,相亲,临时事假,打卡异常',',',CONCAT('''',',',''''))),'''')) FROM DUAL;
1.ORACLE:
SELECT (''''||(REPLACE('公假,相亲,临时事假,打卡异常',',',''''||','||''''))||'''') FROM DUAL;
2.MYSQL:
SELECT (CONCAT('''',(REPLACE('公假,相亲,临时事假,打卡异常',',',CONCAT('''',',',''''))),'''')) FROM DUAL;