SQL Language (MOSC)

MOSC Banner

How to create additonal rows (for Report purpose) from a record in SQL*PLUS?????

edited Feb 18, 2010 5:31AM in SQL Language (MOSC) 23 commentsAnswered
Hi, we have a table with the following fields.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center