1、【通过pivot函数实现】

2、测试结果

1步：搭建环境

SQL> select * from t1;

ID NAME
---------- --------------------
1 a
2 b
3 c
4 d

2步：检查表结构

SQL> desc t1;

Name Null? Type
----------------------------------------------------- -------- ------------------------------------
ID NUMBER(38)
NAME VARCHAR2(20)

3步:    【通过pivot函数实现】

SQL> select * from t1 pivot(max(name) for id in (1 as name1, 2 as name2,3 as name3, 4 as name4));

NAME1 NAME2 NAME3 NAME4
-------------------- -------------------- -------------------- --------------------
a b c d

SQL>