To add more calculated fields to the report...

Hi, I have a oracle table with these 4 columns.  I want to write a SQL query to produce a report as indicated below.  Can SQL*PLUS do it?  Please help.

Asset Name      Amount Paid Pay Starts Period(Month)
--------------- ----------- ---------- -------------
Oracle Accounts $3,600       01-NOV-09       6
Oracle Accounts $7,200       01-NOV-09       6 

Here is the report I want,

Asset Name      Amount Paid Pay Starts Period(Month) 01-NOV-09 01-DEC-09 01-JAN-10 01-FEB-10 01-MAR-10 01-APR-10
--------------- ----------- ---------- ------------- --------- --------- --------- --------- --------- ---------
Oracle Accounts $3,600      01-NOV-09       6        $600      $600      $600      $600      $600      $600
Oracle Accounts $7,200      01-NOV-09       6        $1200     $1200     $1200     $1200     $1200     $1200

Thanks.