Slit Comma Separate Values in Rows through SQL (Oracle)
with rws as ( select item_id,vehcile_id str from ITEMS_APPLICATIONS ) select item_id,regexp_substr ( str, '[^,]+', 1, level ) value from rws connect by level <= length ( str ) - length ( replace ( str, ',' ) ) + 1