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?