There are many reasons why you should install APEX, even if you don’t plan on running APEX (perish the thought). The APEX_STRING PL/SQL utility is just one of them. Learn how to solve everyday string-related problems with the Swiss Army Knife of APEX utilities.
Useful Links:
Oracle APEX API Reference
Jon’s blog on the subject
https://blog.cloudnueva.com/apexstring-apis
Jon Dixon has been working with Oracle technologies since 1996. As an employee of Oracle Consulting for 18 years, he was focused on delivering integrations and extensions for Oracle E-Business Suite and Fusion ERP Cloud Applications. Over the past eight years (or so), Jon has focused on delivering innovative solutions using Oracle APEX and ORDS.