使用Oracle SQL从基于正则表达式从另一个表中拆分的表中进行选择

I have a query that runs on a CLOB, splits the column up, and filters based on a string. Here's the query:I have a query that runs on a CLOB, splits the