SELECT SUBSTR(lx,2*level-1,1) from ( SELECT LX FROM JYJ_XX WHERE DM = 'S00001' AND YXFLAG = '1' ) connect by substr(lx,2*level-1,1) is not null
oracle 11g 截取字符窜的方法 根据特殊的字符
最新推荐文章于 2024-04-30 10:30:39 发布
SELECT SUBSTR(lx,2*level-1,1) from ( SELECT LX FROM JYJ_XX WHERE DM = 'S00001' AND YXFLAG = '1' ) connect by substr(lx,2*level-1,1) is not null