oracle instr substr 根据特殊符号截取并且转多列

        select * from (
       select 
        p1.first, 
       substr(p1.last,0,instr(p1.last,'-',1,1)-1) as second_p_name,
        regexp_substr(p1.last,'[^-]+',2,2) as company_name
        from (
       select 
       substr(p.first,0,instr(p.first,'-',1,1)-1) first,
        substr(p.last,instr(p.last,'-',0,1)+1,length(p.last)) last 
       from (
        select substr(t.implementer,0,instr(t.implementer,';',1,1)-1) first,
        substr(t.implementer,instr(t.implementer,';',1,1)+1,length(t.implementer)) last 
       from t_ows_rfc_his t) p) p1) 
       UNPIVOT(p_name FOR TYPE IN(first,second_p_name))

select  contact_list
  from TRACE_CLOSE_PERSON_MERGE_SYNC unpivot((contact_list) for TYPE in(CONTACT_TYPE_LIST,
                                                               CONTACT_TYPE_ISSUE_LIST));