AnsweredAssumed Answered

Gel Query special characters

Question asked by Rajani on Oct 17, 2013
Latest reply on Oct 18, 2013 by Rajani
Hello,

I need to use the following query in a gel script and its failing due to the use of special characters. Please advice on how to reformat the query.

select regexp_substr('name1;name2;name3;name4','[^;]+', 1, level) as res from dual
connect by regexp_substr('name1;name2;name3;name4', '[^;]+', 1, level) is not null;

Thank you,
Rajani.

Outcomes