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

Porting Oracle Programs and Sub-Procedures to Postgres: A Step-by-Step Guide

Understanding Triggers in Oracle: A Deep Dive into the Correct Implementation

Understanding Infinite Loops with DBMS_UTILITY.COMPILE_SCHEMA in Oracle PL/SQL

Connecting to Oracle Database from R Using PL/SQL Settings and RODBC Packages

Configuring SOLR Query to Find Singular and Plural Forms of Words

Resolving ORA-06502 Errors in Oracle PL/SQL: Variable Declarations and String Manipulation

How to Create a Parameterized Function with System Date Default in Oracle: Best Practices and Tips