sql
咿呀咿哦
这个作者很懒,什么都没留下…
展开
-
oracle 字段字符串分隔列转行
SELECT a.TESTEQUIPCODE,a.PORTNO,a.PRESSRANGE,a.PRESSJD,REGEXP_SUBSTR (a.PRESSNO, '[^,]+', 1, lv) PRESSNO,REGEXP_SUBSTR (a.bpressno, '[^,]+', 1, lv) bpressno,REGEXP_SUBSTR (a.EXPIREDATE, '[^,]+', 1, lv) EXPIREDATEFROM test a, ( SELECT LEVEL原创 2021-07-12 09:41:01 · 274 阅读 · 0 评论 -
oracle 单字段、多字段行转列
oracle 行转列(单字段)--CHBGID,bw1为数据库原字段;beiyong, cdbh 为临时字段;in()里面的为需要转列的字段select CHBGID,bw1 , beiyong, cdbh from BG_CHJL unpivot (cdbh for beiyong in (cdbh1,cdbh2,cdbh3,cdbh4,cdbh5,cdbh6,cdbh7,cdbh8))WHERE CHBGID = '109624' ORDER BY BW1 ,TO_NUMBER(cdbh)原创 2021-01-29 14:32:40 · 1031 阅读 · 0 评论