Compare the string with other string using regular expression in oracle

Question

I have an input string "xyz" to function either in upper or lower case.

In this, I have to compare against the string "test|xyz|test1|xyz1". if it found, I have to return 'Y'. Is there any in built function or regular expression available to perform this check in oracle.

Do you have test|xyz|test1|xyz1 in a table ?

Ashish Gaur
– Ashish Gaur

2013-09-11 11:30:16 +00:00
Commented Sep 11, 2013 at 11:30 — Ashish Gaur
– Ashish Gaur, Commented Sep 11, 2013 at 11:30

DB_learner · Accepted Answer · 2013-09-11 11:40:11Z

1

 Select 'Y' from dual where regexp_like('test|xyz|test1|xyz1','xyz','i');

It will return result only for matched values. If you want 'n' for unmatched values then try regular expression instring.

Or you can do it simply with lower() function on both side and checking for instring.

select case when 
       regexp_instr('test|xyz|test1|xyz1','XYz',1,1,1,'i') > 0 then 'y'
       else 'n' end col1 
from dual

edited Sep 11, 2013 at 11:40

answered Sep 11, 2013 at 11:33

DB_learner

1,0369 silver badges15 bronze badges

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

1 Comment

Noel Over a year ago

@user2750658, are u sure this is what you need? this will match xyz with test|test1|xyz1 also.

Collectives™ on Stack Overflow

Compare the string with other string using regular expression in oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related