The final answer is:

Updating Rows in an Oracle Database: A Conditional Update Solution Using SQL Queries

Efficiently Importing Data from Non-Partitioned Tables into Partitioned Tables Using Oracle Datapump

Understanding Quarter Lookback Periods in Oracle Databases: A Practical Guide to Dynamic SQL Queries