oracle数据库字段中含有逗号分隔的字符串转列

SELECT DISTINCT REGEXP_SUBSTR (字段名,'[^,]+',1,LEVEL) FROM 表名 CONNECT BY REGEXP_SUBSTR (字段名,'[^,]+',1,LEVEL) IS NOT NULL

注意：如果字段中有重复值则会查出null数据，需要在外层处理

例如：表 SYS_FLOW_SP_USER  中字段USERS为用户id逗号分隔，管理用户表SYS_LOGIN，查询所有转列后的数据

SELECT L.USER_NAME from ( SELECT DISTINCT REGEXP_SUBSTR (USERS,'[^,]+',1,LEVEL) as userId
  FROM SYS_FLOW_SP_USER  
 CONNECT BY REGEXP_SUBSTR (USERS,'[^,]+',1,LEVEL) IS NOT NULL) A LEFT JOIN SYS_LOGIN L on A.userId=L.USER_ID where A.userId is not null