I need a simple replace function which replaces a semicolon delimited list of strings to quoted comma delimited strings.
'123;Asd;_P1;' replaces to '123', 'Asd', '_P1'
Tried this but the last string missed the quotes and also string can have other chars.
SELECT REGEXP_REPLACE('123;234;345;123','([[:alnum:]]+);', '''\1'',') List FROM DUAL;
I don't think you need regexp_replace here, a simple replace should be sufficient. It appears that you just want to replace a semicolon with the string "', '" and then add a single quote before and after the string.
select q'{'}' ||
replace( '123;234;345;123', ';', q'{','}' ) ||
q'{'}'
from dual
WHERE Col1 IN (q'{'}' || replace('MK2.3;P002;0001112', ';',q'{','}') || q'{'}')) Can you please let me know what I am missing?
WHERE clause. You can parse a delimited string to populate a collection and use that collection in your query asktom.oracle.com/pls/apex/…SELECT REGEXP_REPLACE( REGEXP_REPLACE('123;234;345;123','([[:alnum:]]+);', '''\1'','), ',([[:alnum:]]+)', ',''\1''') FROM DUAL;
