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

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

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

Understanding Full Table Scans with PL/SQL Tables: Mitigating Performance Bottlenecks in Oracle Databases.

Using Arrays in Stored Procedures with SOA Oracle: A Step-by-Step Guide

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

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