Parsing data in oracle sql using substr
Posted on 2011-03-07
Trying to parse data in a field
data has the following C3,5,35
need it to look like this
Repair Code1 Repair Code 2 Repair Code 3
C3 5 35
REGEXP_SUBSTR (NVL (historical_separate.work_done, active_separate.work_done),'[^,]+') "Repair Code1", What are the next statements to get repair code 2 and repair code 3?