①只包含数字字符和符合:
直接使用reverse,oracle中未申明的函数
包含汉字时:
②listagg:
GROUP(
ORDER BY ord)
FROM (SELECT rownum ord, substr('测试reverse', LEVEL * -1, 1) str
FROM dual
CONNECT BY LEVEL <= length('测试reverse'));
③ wm_concat+replace
select replace(wm_concat(str),',','') from
(SELECT rownum ord, substr('测试reverse', LEVEL * -1, 1) str
FROM dual
CONNECT BY LEVEL <= length('测试reverse'))