Guess you want a CROSS TAB report. I don't know if Oracle 9i has incorporated any feature. The best bet for you is to traverse a
PL/SQL cursor and do it your self as functions can return a value or valueset as you wish !


Cheers
Nandu