Tags / oracle12c
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
Using Arrays in Stored Procedures with SOA Oracle: A Step-by-Step Guide
Looping Through a JSON Array in PL/SQL 12.1: Alternatives to JSON_TABLE Function
Understanding Oracle's Aggregate Function Ordering Behavior: When Average Goes Wrong with Group By Clauses