This discussion is archived
3 Replies Latest reply: Nov 14, 2012 11:08 PM by SreekeshavaS RSS

Query to apply regexp_like for patterns specified in different table

SreekeshavaS Newbie
Currently Being Moderated
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 ?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points