当前位置:首页 > 技术专区 >

oracle 行转列

 有表      CAT 字段有  A B CD 四种类型

  CAT          DATE
  A                   20160101
B                   20160202
C                    20160403
D                  2016 0501
要转换成

CAT      20160101          20160202            20160403                  20160501
A               1
B                                                1
C                                                                                1
D  

                                                                                                              1

 

报名热线 021-62932189