Oracle 返回有效号段

欧巴酱

于 2021-02-02 18:12:31 发布

阅读量156

点赞数

本文链接：https://blog.youkuaiyun.com/qq_36894527/article/details/113571155

版权

select *
  from (select min(b.kpid) SKPID, max(b.kpid) EKPID
          from (select a.kpid,
                       to_number(REGEXP_REPLACE(kpid, '[^0-9]', '') - rownum) cc
                  from (select *
                          from kpda
                           where kquser='CSKQ'
                           and KHID_LK='111111'
                         order by kpid) a) b
         group by b.cc)
 order by SKPID

ps：regex_reppace 方法主要是为了处理部分字段还有特殊字符