3 Replies Latest reply: Nov 15, 2012 1:08 AM by Sreekeshava S RSS

    Query to apply regexp_like for patterns specified in different table

    Sreekeshava S
      Hi all,

      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 ?