Oracle 多行分多列

Select * FROM (
 Select sprid,RWID,spsj,spyj,sprmc
              from T_PROJ_DBRW_SPYJ
              Where  sprid In('A','B','C','D')
              --And RWID in(56295,56186)
)
pivot( 
  Max(spsj) spsj,Max(spyj) spyj,Max(sprmc) sprmc For sprid In('A' A,'B' B,'C' C,'D' D)           
)

https://www.bilibili.com/read/cv25571204/

 

select a.userid,a.username,
level lev,
regexp_count(a.REMARK,'[^|]+') as regcou,
regexp_substr(a.REMARK,'[^|]+',1,level) as deptid 
from sys_user_EMPLOYEE a 
Where a.REMARK Is Not Null
connect by prior a.userid = a.userid
and prior dbms_random.value is not null
and level <= regexp_count(a.REMARK,'[^|]+')

列转行，使用 | 分隔

 

select ztid,to_char(wm_concat(hf)) name From (
Select ztid,to_char(clrxm)||' 于 '||to_char(clsj,'yyyy-MM-dd HH24:mi')||' 回复: '|| nr ||'\n' hf
FROM V_DDSX_LYFK
Where ztid>0 And yxzt=1
)
Group By ztid

 

SELECT T.tid,
LISTAGG(hf , CHR(10))
WITHIN GROUP(ORDER BY T.tid)
From
(
Select ztid tid,to_char(clrxm)||' 于 '||to_char(clsj,'yyyy-MM-dd HH24:mi')||' 回复: '|| nr || CHR(13) hf
FROM t_DDSX_LYFK
Where ztid>0 And yxzt=1
)
T
GROUP BY T.tid