Hi All,
Below is my table data, when report date is Saturday, Sundays then i want to update week_end flag as Y. Please help on this.
DB Version : Oracle 12C
| Report_date | Process_instance | Week_End |
| 1-Aug-19 | 123 | |
| 2-Aug-19 | 123 | |
| 3-Aug-19 | 123 | Y |
| 4-Aug-19 | 123 | Y |
| 5-Aug-19 | 123 | |
| 6-Aug-19 | 123 | |
| 7-Aug-19 | 123 | |
| 8-Aug-19 | 123 | |
| 9-Aug-19 | 123 | |
| 10-Aug-19 | 123 | Y |
| 11-Aug-19 | 123 | Y |
| 12-Aug-19 | 123 | |
| 13-Aug-19 | 123 | |
| 14-Aug-19 | 123 | |
| 15-Aug-19 | 123 | |
| 16-Aug-19 | 123 | |
| 17-Aug-19 | 123 | Y |
| 18-Aug-19 | 123 | Y |
| 19-Aug-19 | 123 | |
| 20-Aug-19 | 123 | |
| 21-Aug-19 | 123 | |
| 22-Aug-19 | 123 | |
| 23-Aug-19 | 123 | |
| 24-Aug-19 | 123 | Y |
| 25-Aug-19 | 123 | Y |
| 26-Aug-19 | 123 | |
| 27-Aug-19 | 123 | |
| 28-Aug-19 | 123 | |
| 29-Aug-19 | 123 | |
| 30-Aug-19 | 123 | |
| 31-Aug-19 | 123 | Y |