I can help with some of the issues you're facing.

Converting Oracle Timestamps to ISO-8601 Date Datatype: A Step-by-Step Guide

Optimizing SQL Joins with Date-Based Filters: Strategies for Improved Performance

Optimizing Oracle 12c Joins: Efficient Joining of Max Date Record

Update a Flag Only If All Matching Conditions Fail Using Oracle SQL

Using the ANY Function and Greatest or Least Functions for Efficient Null Value Checking in Oracle SQL Queries

Using Common Table Expressions (CTEs) in Oracle: Simplifying Updates with Derived Tables and MERGE Statement