How to convert row to columns

[ap63]

Hi,

Let me give you an example. I have a table with two column as bellow:

id tracking_number
2 1111
2 2222
2 3333
2 4444
2 5555

I want the result that looks like this: (in single row with multiple columns)
id trk_num1 trk_num2 trk_num3 trk_num4 trk_num5
1 1111 2222 3333 4444 5555

Please let me know how to write a query.
Thanks in advance

[PAVB]

Search this forum for pivot query.

[sridhar.dbe]

hi
try this one

with data
as
(
select 1 "ID",1111 "TNUM" from dual union all
select 1, 2222 from dual union all
select 2, 1111 from dual union all
select 2, 2222 from dual union all
select 2, 3333 from dual union all
select 2, 4444 from dual union all
select 2, 5555 from dual )
select id,max(decode(rn,1 ,TNUM)) "trk_num1",
max(decode(rn,2 , TNUM)) "trk_num2",
max(decode(rn,3 , TNUM)) "trk_num3",
max(decode(rn,4 , TNUM)) "trk_num4",
max(decode(rn,5 ,TNUM)) "trk_num5"
from (
select id,TNUM,
row_number() over (partition by id order by id) rn
from data)
group by id