字符串倒置
SELECT max(replace(SYS_CONNECT_BY_PATH (c, '/'), '/')) keep (dense_rank last order by level) re
FROM (SELECT LEVEL lvl, SUBSTR ('國和共民人華中', LEVEL, 1) c
FROM (SELECT LENGTH ('國和共民人華中') len
FROM DUAL) x
CONNECT BY LEVEL <= x.len
ORDER BY 1 DESC)
CONNECT BY PRIOR lvl = lvl + 1
FROM (SELECT LEVEL lvl, SUBSTR ('國和共民人華中', LEVEL, 1) c
FROM (SELECT LENGTH ('國和共民人華中') len
FROM DUAL) x
CONNECT BY LEVEL <= x.len
ORDER BY 1 DESC)
CONNECT BY PRIOR lvl = lvl + 1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/785120/viewspace-332299/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
罗马数字 转 阿拉伯数字
下一篇：
Oracle 中HINT的使用
请登录后发表评论
登录
全部评论
