Rabu, 04 Februari 2015

Oracle Split space delimited string with regexp SQL

SELECT regexp_substr('B 123 CC','[^ ]+', 1, 1) AS KodeWilayah,
                regexp_substr('B 123 CC','[^ ]+', 1, 2) AS Nomor,
                regexp_substr('B 123 CC','[^ ]+', 1, 3) AS KodeWilayahKab FROM DUAL;