如何将Oracle SQL查询的结果转换为列？

输出可以实现如下-

建立：-

CREATE TABLE TAB1
(
  ID NUMBER,
  ATTRNAME VARCHAR2(1024),
  ATTRVALUE VARCHAR2(1024)
);


insert into tab1 values (1, 'Name', 'Mark');
insert into tab1 values (1, 'Email', '[email protected]');
insert into tab1 values (1, 'Phone num', '12234');

insert into tab1 values (2, 'Name', 'Julie');
insert into tab1 values (2, 'Email', '[email protected]');
insert into tab1 values (2, 'Phone num', '12234');

查询：

select * from (
  select * from tab1)
pivot(
  max(attrvalue) for attrname in ('Name', 'Email','Phone num')
  ) order by id;

结果：-

ID  'Name'  'Email' 'Phone num'
1   Mark    [email protected] 12234
2   Julie   [email protected] 12234