create table test_exp
(s_desc Varchar2(100))Table created.
insert into test_exp
values('NOK 8.0.1 D81SupiriorCoachStorePUJI')1 row(s) inserted.
insert into test_exp
values('NOK D81CoachStorePUJI')1 row(s) inserted.
insert into test_exp
values('NOK D81TesterCoachStorePUJI')1 row(s) inserted.
insert into test_exp
values('NOK D81RacketPUJI')1 row(s) inserted.
insert into test_exp
values('D81QACoachStorePUJI')1 row(s) inserted.
insert into test_exp
values('NOK D81QAPatchPUJI')1 row(s) inserted.
insert into test_exp
values('NOK D8StorePQRST')1 row(s) inserted.
select * from test_exp| S_DESC | NOK D8StorePQRST | NOK 8.0.1 D81SupiriorCoachStorePUJI | NOK D81CoachStorePUJI | NOK D81TesterCoachStorePUJI | NOK D81RacketPUJI | D81QACoachStorePUJI | NOK D81QAPatchPUJI |
|---|
select s_desc from test_exp where REGEXP_LIKE(s_desc,'[D81]*(Store)')| S_DESC | NOK D8StorePQRST | NOK 8.0.1 D81SupiriorCoachStorePUJI | NOK D81CoachStorePUJI | NOK D81TesterCoachStorePUJI | D81QACoachStorePUJI |
|---|
select s_desc from test_exp where REGEXP_LIKE(s_desc,'[D81][^(Tester|QA)]*(Store)')| S_DESC | NOK D8StorePQRST | NOK D81CoachStorePUJI |
|---|