oracle的列转行的问题

列转行有两种表示：

第一种是分别把每个级别的的价格合成总数：

 select *
  from talbe
  pivot (sum( N_PRICE) for vc_level in ('初级' as primary,'中一级' AS middleLevel,'中二级' AS secondary,'中三级' AS secondaryThree,'高一级' AS highLevel,
  '高二级' AS highLevelTwo,'高三级' AS highThird,'深资' AS deepCapital,'专家' AS expert,'黑客' AS hacker))

 

第二种默认用逗号隔开:

  select
       em.vc_id,
       wm_concat(t.remarks) as remarks,
      
       from table em
  group by 
      em.vc_id

或者自定义符号隔开：

  select
       em.vc_id,
      REPLACE((wm_concat (t.remarks)) ,',','#') as remarks,
       from table em
  group by 
      em.vc_id