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.
Oracle APEX API Reference
Jon’s blog on the subject
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.