oracle 行转列

select '{' || d.il1_id || '}{' || d.il2_id || '}{' || d.il3_id || '}{' ||
       d.il4_id || '}{' || d.il5_id || '}' ids
  from t_dept d
 where d.idept_id = 1878;
 

select regexp_replace(regexp_substr((select '{' || d.il1_id || '}{' ||
                                           d.il2_id || '}{' || d.il3_id || '}{' ||
                                           d.il4_id || '}{' || d.il5_id || '}'
                                      from t_dept d
                                     where d.idept_id = 1878),
                                    '{([0-9]*)}',
                                    1,
                                    level),
                      '^{(.*)}$',
                      '\1')
  from dual
connect by level <= 5;