Thanks for the reply.
I can achieve this applying PL/SQL but i was trying to avoid taking that route. If any functions exist within SQL so that just a SQL query can achieve a horizontal resultset would be ideal.

Thanks.