Oracle SQL Regex Non-matching comma

Question

We have defined a grammar and are storing expression strings in our database that follow this grammar. One possible term in our expressions is IIF(condition, then, else). I need to query our expressions table for all expressions that contain a '+' in the condition of an IIF.

What I am trying to do with this statement below is search for conditions with any number of non-comma characters followed by a '+' followed by any number of non-comma characters followed by a comma. Where am I going wrong?

select * from ... and value like '%IIF([^\,]*\+[^\,]*\,%';

Are you sure that the LIKE operator accepts regular expressions at all? — Álvaro González
– Álvaro González, Commented Mar 3, 2014 at 16:04

Patrick Bacon · Accepted Answer · 2014-03-03 16:28:59Z

2

Using REGEXP_LIKE would work for this type of query. The REGEXP_LIKE function would be called in the where clause and the parameters for the function call would look something like this:

WHERE REGEXP_LIKE (column_xyz, '.*IFF\([^,]*\+[^,]*,')

answered Mar 3, 2014 at 16:28

Patrick Bacon

4,7101 gold badge31 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL Regex Non-matching comma

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related