问string_split函数

EN

 MYTABLE

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FIELD1                                    NOT NULL VARCHAR2(2)
 FIELD2                                    NOT NULL VARCHAR2(2)
 FIELD1                                    NOT NULL VARCHAR2(2)

WITH INPUT AS ( 
               select 'A-12-AB' as string_input from dual union 
               select 'P-13-PQ' as string_input from dual union 
               select 'N-14-NM' as string_input from dual
              )
insert into MYTABLE
select regexp_substr(input.string_input, '[^-]+', 1, 1) as field1,
       regexp_substr(input.string_input, '[^-]+', 1, 2) as field2,
       regexp_substr(input.string_input, '[^-]+', 1, 3) as field3
  from INPUT;