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

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

Replacing String with Another String Plus Respective Position: A Deep Dive into Regular Expressions and Recursive CTEs

Understanding Index-Organized Tables (IOTs) in Oracle: A Comprehensive Guide to Creating and Managing IOTs

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

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