Is there any way I can duplicate the efect of the MS SQL Server Functions
TRANSFORM & PIVOT on Oracle?

Thank You.

PS. I posted this question on the Oracle-General group 2 weeks ago but nobody
replied.