Locate Substitution String in clob Template column using regexp
Last time I wanted to locate the substitution strings in clob template column. I suppose there is no handy code for this. After searching asktom, I got some idea from this anwser and I composed three functions to get what I wanted. Today I updated them and it's available as a package in my github folder: UTL_APEX_SUBSTITUTIONSTR.sql . There are three functions in this package. -------------------------------------------------------------------------------------- -- locate all substitution strings from template HTML source -- input: p_clob, HTML source of template -- output: return all substitution string in HTML source function locate_all_substitutionstr(p_clob in clob) return t_locate_tab pipelined; -------------------------------------------------------------------------------------- -- locate specified substitution string or keywords in attribute peer from template HTML source -- (e.g. id="#REGION_STATIC_ID#_heading", onclick="htmldb_Toggl...