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.