oracle 多列变一行,ORACLE 一行變多列

一行變多列

SQL> select * from a3;

ID        ID1        ID2

---------- ---------- ----------

1          2          3

SQL>

SQL> select decode(column_name,column_name,column_name) name,

2         decode(column_name,'ID',ID,'ID1',ID1,'ID2',ID2) value

3  from user_tab_columns u,A3 t

4  where u.table_name='A3';

NAME                                VALUE

------------------------------ ----------

ID                                      1

ID1                                     2

ID2                                     3