Data Experts Help Needed Please Help Me Version 2

[massmaharaj]

recently i came up this one question few of db'ians helped

but as business is saying performance will be slow

they suggested in other way

a b
1 aaa| bbb| ccc|



output should be


a b1 b2 b3
1 aaa bbb cccc

i have seen like google

canyou please help me how we can we convert a column in to multiple columns

there might be 150 codes all 150 codes should split in to 150 columns

[vikuba]

clarity please..

[massmaharaj]

[color=#282828][font=helvetica, arial, sans-serif]input [/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]a b[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]1 aaa| bbb| ccc|[/font][/color]



[color=#282828][font=helvetica, arial, sans-serif]output should be[/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]a b1 b2 b3[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]1 aaa bbb cccc[/font][/color]

[font="helvetica, arial, sans-serif"][color="#282828"] [/color][/font]

[color=#282828][font=helvetica, arial, sans-serif]canyou please help me how we can we convert above B column in to multiple columns (b1,b2,b3)[/font][/color]

[RE8EL]

do you want to do in UNIX/ETL?etc etc....

[mettastar]

Do you know how many pipes will be there in column b?