ORACLE 一行變多列

一行變多列

SQL> select * from a3;ITPUB个人空间4e-c ^'D8@8`
}{E
 ITPUB个人空间f\
H
GF j%x)f[
        ID        ID1        ID2
I?8R&}9x!rF%V7590422---------- ---------- ----------ITPUB个人空间+Jw-g3R[2xwF+_
         1          2          3ITPUB个人空间$zSSY\7Y6]0T"j
 
RI`-r~0@}7590422SQL>ITPUB个人空间,Ol#R
hW9k
SQL> select decode(column_name,column_name,column_name) name,
;O Jd"iH3Ad+|7590422  2         decode(column_name,'ID',ID,'ID1',ID1,'ID2',ID2) valueITPUB个人空间gwic"YMWx.Q
  3  from user_tab_columns u,A3 tITPUB个人空间$K$i"UnF)L8~ZrBf
  4  where u.table_name='A3';ITPUB个人空间
WG8}1H/EY5Hfop
 ITPUB个人空间y,\:Z
rv+EK
NAME                                VALUEITPUB个人空间4ywP5~8K1qG ROm
------------------------------ ----------
pz B!wj-M9u7590422ID                                      1
J!b R*XW#IO7590422ID1                                     2
Z-Zp
~}GS7590422ID2                                     3ITPUB个人空间0y2rN&v[2d