with table trap_store as ( vb clob) and table conf as (patten varchar2(20))
Need to retrieve records from trap_store where data in vb column matches patterns in conf table.
Presently planning to use regexp_like function ie; regexp_like(vb,'Start').
In the above query, have hardcoded the pattern as 'Start'. But, Patterns are present in different conf table. Each row of trap_store table ie; each value of vb column in trap_store table should be matched with all the patterns of conf table.
How to apply all the patterns of conf table ?