Oracle 如何使行到列

create table emp_det
( name varchar2(15),
occupation varchar2(15)
);

insert into emp_det values('samantha','doctor');
insert into emp_det values('julia','actor');
insert into emp_det values('maria','actor');
insert into emp_det values('meera','singer');
insert into emp_det values('ashley','professor');
insert into emp_det values('ketty','professor');
insert into emp_det values('jane','actor');
insert into emp_det values('jenny','doctor');
insert into emp_det values('priya','singer');
commit;

doctor   professor   singer   actor
jenny    ashley      meera    jane
samantha ketty       priya    julia
null     null        null     maria

set null 
with rws as (
  select e.*, 
         row_number() over (partition by occupation order by name) rn 
  from   emp_det e
)
  select * from rws
  pivot ( 
    min(name) for occupation in ('doctor', 'actor', 'singer', 'professor')
  );

set null 
with rws as (
  select e.*, 
         row_number() over (partition by occupation order by name) rn 
  from   emp_det e
)
  select * from rws
  pivot ( 
    min(name) for occupation in ('doctor', 'actor', 'singer', 'professor')
  );