Приведение таблицы к другому виду

create table table14 (id number,QUARTAL number, value number);
insert into table14 values (1,1,10);
insert into table14 values (1,2,20);
insert into table14 values (1,3,30);
insert into table14 values (1,4,40);
insert into table14 values (1,1,11);
insert into table14 values (2,2,22);
insert into table14 values (3,3,33);
insert into table14 values (4,4,44);

ID   VALUE(QUARTAL=1)       VALUE(QUARTAL=2)       VALUE(QUARTAL=3)       VALUE(QUARTAL=4)
1                10                20                       30                     40
2                11                22                       33                     44

SELECT *
FROM
(select id,QUARTAL, value from table14)
PIVOT
(
  sum(value)
  FOR QUARTALIN(1,2,3,4)
)
order by id;