1、多列转一行
select wm_concat(t.name) from AC_CENTER_SCREEN t
2、行转多列
select regexp_substr((select center_people_id from ac_center_duty_plan),’[^,]+’, 1, level) as para_code1 from dual
connect by regexp_substr((select center_people_id from ac_center_duty_plan),’[^,]+’, 1, level) is not null