The following are examples to split a string in Oracle using SQL query. Split a String Using regexp_substr() Function in Oracle The below query will split the string separated by comma using regexp_substr() function: select regexp_substr('A,B,C,D', '[^,]+', 1, level) from ...