<div>
if &quot;l_search&quot; &nbsp;is a string like &nbsp;this <br />
<br />
<br />
'(something)' &nbsp; &nbsp; the () &nbsp;are regular expression delimiters to identify &quot;something&quot; as pattern.<br />
<br />
if you want to search for the parentheses characters themselves. &nbsp;you must prefix them with &quot;\&quot;<br />
<br />
try modifying l_search like this...<br />
<br />
replace(replace(l_search,'<wbr />(','\('),'<wbr />)','\')
</div>


if "l_search"  is a string like  this


'(something)'     the ()  are regular expression delimiters to identify "something" as pattern.

if you want to search for the parentheses characters themselves.  you must prefix them with "\"

try modifying l_search like this...

replace(replace(l_search,'(','\('),')','\')

<div>
<div class="content wysiwyg-content">
I have been using the below code to do a key down filter using ajax but now I realize the regexp_like is not seeing the ( and ) as normal characters.<br />
Should I be using this regexp_like here?<br />

<pre><code id="code-8227415">select group_name, group_id, rownum r from ( 
			 select group_name, group_id
			   from um_groups
			  where group_type_id = 2
			    and regexp_like( group_name,
				   nvl(l_search,group_name), 'i' )
			    and nvl(instr(':'||l_selected||':',
					 ':'||group_id||':'),0)=0 
			    and status_id = nvl(l_status_filter,1)
			  order by 1)</code></pre>
</div>
</div>


I have been using the below code to do a key down filter using ajax but now I realize the regexp_like is not seeing the ( and ) as normal characters.
Should I be using this regexp_like here?

REGEXP_LIKE ?? Should I use

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.