Q&A BY TAG 'regexp_like'
Help rewriting REGEXP_LIKE Query to VQL
answered
16-04-2021 05:39:36 -0400
We are needing some assistance/suggestions in rewriting the following Oracle query. Query is basically creating a list(listagg) of a list of regions gathered from abc.table123 (security config table, each row is different region), and then needs to be ...
Answers:
1
VQL REGEXP_LIKE regexp_like Oracle SQL to VQL Converter SQL to VQL to_char
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 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
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