| | | |

2017年9月22日

摘要： WITH t AS (SELECT '1,2,3,4' a, 1 b FROM Dual UNION ALL SELECT '1,2,3' a, 2 b FROM Dual),p AS (SELECT 1 c, 'A' d FROM Dual UNION ALL SELECT 2 c, &# 阅读全文

posted @ 2017-09-22 16:14 simplelil 阅读(281) 评论(0) 推荐(0)

oracle 拆分字符串

摘要： WITH t AS (SELECT '1-2-3-4' a FROM dual)SELECT Regexp_Substr(a, '[^-]+', 1, LEVEL) i FROM tCONNECT BY LEVEL <= Regexp_Count(a, '-') + 1 阅读全文

posted @ 2017-09-22 16:13 simplelil 阅读(216) 评论(0) 推荐(0)