ORACLE 一行變多列

一行變多列

SQL> select * from a3;
](C+p7ymkz0 ITPUB个人空间S.h3OjU!y2Cd?;[Y
        ID        ID1        ID2ITPUB个人空间-j.Yx,N!t wg
---------- ---------- ----------
|*F*J|fmS%[%w0         1          2          3ITPUB个人空间'xp"LVX
 ITPUB个人空间 }D W8v;d4h
SQL>ITPUB个人空间%w ^ b&T7SU ?
SQL> select decode(column_name,column_name,column_name) name,ITPUB个人空间I"f-a$t|p
  2         decode(column_name,'ID',ID,'ID1',ID1,'ID2',ID2) valueITPUB个人空间6f:y*Y3{O
  3  from user_tab_columns u,A3 tITPUB个人空间b'bF@6l6g
  4  where u.table_name='A3';ITPUB个人空间R,rzjN's
 ITPUB个人空间)d,r'TR {q?
NAME                                VALUE
X V7Eo({ C\S0------------------------------ ----------ITPUB个人空间,`'@*^){'cY+aj-aj
ID                                      1ITPUB个人空间 M
so
sa#ml,k+jgO
ID1                                     2ITPUB个人空间-Td(E hI'R t
ID2                                     3
]T g il9G0