REGEXP_SUBSTR to split delimited values I have a field called FREQUENCY and it has values like '10,0;30'. How do I write a regular expression to get the result like this:
FREQUENCY 

10
0
30
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;.