Troubleshooting SQL Query Issues When No Rows Are Returned

REGEXP_REPLACE and String Manipulation in Oracle SQL: A Different Approach Using Auxiliary Functions