PL/SQL (MOSC)

MOSC Banner

Return Accruals

edited Jun 5, 2018 5:10AM in PL/SQL (MOSC) 1 commentAnswered

Hello Everyone,

I would like to write a plsql which return complete table and same insert into a separate table, the available data which i have is as bellow:

I am attaching my working sheet, in first sheet mention my available data and in second sheet green highlighted fields my desire results. 

   

IncomeDisbursement Date18-Dec-17
1,266,666.67Rental Dates18-Mar-18
1,232,432.4318-Jun-18
1,198,198.2018-Sep-18
1,163,963.9618-Dec-18
1,129,729.7318-Mar-19
1,095,495.5018-Jun-19
1,061,261.2618-Sep-19
1,027,027.0318-Dec-19
992,792.7918-Mar-20
958,558.5618-Jun-20
924,324.3218-Sep-20
890,090.0918-Dec-20
855,855.8618-Mar-21
821,621.6218-Jun-21
787,387.3918-Sep-21
753,153.1518-Dec-21
718,918.9218-Mar-22
684,684.6818-Jun-22
650,450.4518-Sep-22
616,216.2218-Dec-22
581,981.9818-Mar-23
547,747.7518-Jun-23
513,513.5118-Sep-23
479,279.2818-Dec-23
445,045.0518-Mar-24
410,810.8118-Jun-24
376,576.5818-Sep-24
342,342.3418-Dec-24
308,108.1118-Mar-25
273,873.8718-Jun-25
239,639.6418-Sep-25
205,405.4118-Dec-25
171,171.1718-Mar-26
136,936.9418-Jun-26
102,702.7018-Sep-26
68,468.4718-Dec-26
34,234.2318-Mar-27

The result which i want to extract in table from my saved data is as bellow:

Tagged:

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