Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Splitting work hours into days

User_CRU78Jul 31 2022

hi i'm beginner in oracle, I want to split 2 tasks into days with stored procedure. Each task has a processing time of 10 hours and must be allocated per day which in one day can only work on the task for 8 hours
like this:
TASK A 10 HOUR
TASK B 10 HOUR
-----------------------------------------
1 Aug 22 | 2 Aug 22 | 3 Aug 22
8 Hour A| 2 Hour A | 4 Hour B
| 6 Hour B |
-----------------------------------------

how to get result like this?

This post has been answered by Solomon Yakobson on Jul 31 2022
Jump to Answer
Comments
Post Details
Added on Jul 31 2022
5 comments
162 views