REGEXP_SUBSTR to split delimited values
If you want a single row's value returned without the commas and semi-colons then the easiest way to accomplish this is with the REPLACE() function like this: REPLACE(REPLACE(FREQUENCY, ',', ' '), ';', ' ') &quot;FREQUENCY&quot;.