with t(코드값, 인덱스, 사번, 성명, 전화번호) as ( 
select 'AAAAA1', 1, 'HHH001', '김나나', '010-0000-5678' from dual union all 
select 'AAAAA1', 2, 'HHH002', '강나나', '010-0000-5679' from dual union all 
select 'AAAAA1', 3, 'HHH003', '박나나', '010-0000-5680' from dual union all 
select 'AAAAA1', 4, 'HHH004', '송나나', '010-0000-5681' from dual union all 
select 'AAAAA1', 5, 'HHH005', '최나나', '010-0000-5682' from dual union all 
select 'BBBBB1', 2, 'HHH006', '한니노', '010-0000-5688' from dual union all 
select 'BBBBB1', 4, 'HHH007', '남니노', '010-0000-5689' from dual union all 
select 'BBBBB1', 5, 'HHH008', '현니노', '010-0000-5690' from dual union all
select 'BBBBB1', 6, 'HHH009', '왕니노', '010-0000-5691' from dual
)
select *
from t
PIVOT
(max(사번) as 사번,max(성명) as 성명, max(전화번호) as 전화번호 FOR 인덱스 IN (1,2,3,4,5,6))
order by 코드값;