Can SQL*PLUS create this report??
We have an Oracle table with the following fields.
Asset Name Total Amount Date Begin Period(Month)
----------------------- ------------ ------------ -------------
Oracle Accounts Payable $3,600 01-NOV-09 3
Oracle Accounts Credits $7,200 01-DEC-09 3
We want to create a report for payments based on these fields, and it should look as follows,
Asset Name Total Amount Date Begin Period(Month) 01-NOV-09 01-DEC-09 01-JAN-10 01-FEB-10
----------------------- ------------ ------------ ------------- --------- --------- --------- ---------
Oracle Accounts Payable $3,600 01-NOV-09 3 $1,200 $1,200 $1,200
Oracle Accounts Credits $7,200 01-DEC-09 3 $2,400 $2,400 $2,400
Can we do it by SQL*PLUS? Thanks.
Veronica