Q&A BY TAG 'regexp_like'

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

Answers: 2

REGEXP_LIKE Select Query CASE

REGEXP_LIKE function in a Scheduler query
answered 09-01-2018 08:35:06 -0500

Hello, I am trying to create a job in Scheduler, by putting a REGEXPLIKE function in the sql. The query which works in Oracle is: SELECT FROM mytable WHERE REGEXPLIKE (referer,'^https?://[a-z6.]{0,9}.?google[a-z]{0,11}.[a-z]','i')* But this quer...

Answers: 2

REGEXP_LIKE

Error Deploying Wrapper because of "regexp_like" in condition
answered 26-03-2015 06:26:41 -0400

I am having an issue deploying a wrapper that contains "regexp_like" in a condition for determining if each record that is iterated contains a firstname in the name column that is the same as entered at start. The "contains" function does not work as i...

Answers: 1

VDP regexp_like ITPilot deploy