What is your exact Oracle version.
If you're on 11.1 or higher, you can use PIVOT.
I am Currently using oracle 10G .
"Pivot" is the genereic term for takling 1 column on multiple rows, and displaying it as multiple columns on 1 row.
See the forum FAQ
for different techniques, suitable for different versions of Oracle.
1 person found this helpful
in 10g , you can use something like
max(decode(WALL_DATE, '11-Sep-13', WALL_BAL, null) day_1_bal,
max(decode(WALL_DATE, '06-Sep-13', WALL_BAL, null) day_6_bal
group by MSDNID;
But it only works if you have limited # of days.