How to create additonal rows (for Report purpose) from a record in SQL*PLUS?????
Asset Name Total Amount Pay Starts Period(Month)
---------------- ------------ ------------ -------------
Oracle Accounts $3,600 01-NOV-09 4
Oracle Payable $7,200 01-NOV-09 3
We want to generate a report as below by using SQL*PLUS only.
The report is the payment schedule based on the "Total Amount", "Pay Starts" and "Period". It should look like below.
Payment is the (Total Amount/Period). The Payment Date is determined by "Pay Starts" and Period(Month). The information in red is the thing we
would like to produce from the above record.
Can someone help me on writing a query to produce this report? Thanks.