SQL Language (MOSC)

MOSC Banner

Can SQL*PLUS create this report??

edited Feb 18, 2010 5:30AM in SQL Language (MOSC) 18 commentsAnswered
 Hi, could anyone please help on this?  Thanks.

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

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