谜题62，格式化报表

create table names(name varchar2(15) not null primary key)/insert into namesselect 'A1' from dual union allselect 'Ben' from dual union allselect 'Charlie' from dual union allselect 'David' from dual union allselect 'Ed' from dual union allselect 'Frank' from dual union allselect 'Greg' from dual union allselect 'Howard' from dual union allselect 'Ida' from dual union allselect 'Joe' from dual union allselect 'Ken' from dual union allselect 'Larry' from dual union allselect 'Mike' from dual/select max(case             when mod(sn, 4) = 1 then              name           end) as name1,       max(case             when mod(sn, 4) = 2 then              name           end) as name2,       max(case             when mod(sn, 4) = 3 then              name           end) as name3,       max(case             when mod(sn, 4) = 0 then              name           end) as name4  from (select rownum as sn, name from names) group by ceil(sn / 4) order by 1