Re: How to transpose columns and rows in 9i SQL*Plus

Without providing you with a bespoke solution (sorry!), suffice to say
yes, it can be done. This is basically a cross tabulation problem (or
pivot table, in M'Soft speak). Decode could be used. I suggest you
Google search on 'sql cross tabulation'. Within the first few hits I
found this: