Unlocking Oracle's Powerful JSON Querying Capabilities with the JSON_TABLE Function

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 Common Table Expressions (CTEs) in Oracle: Simplifying Updates with Derived Tables and MERGE Statement

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

Oracle PL/SQL Best Practices: Using ROW_NUMBER() for Unique Composite Keys with Sequences

Resolving ORA-01722 Errors: Best Practices for Converting VARCHAR2 Columns to NUMBER

Looping Through a JSON Array in PL/SQL 12.1: Alternatives to JSON_TABLE Function