oracle把逗号分隔的数据按几行返回

最新推荐文章于 2025-05-24 21:19:19 发布

车字辕

最新推荐文章于 2025-05-24 21:19:19 发布

阅读量237

点赞数 3

CC 4.0 BY-SA版权

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/zheyijieyou/article/details/144064056

oracle 根据逗号，拆分多行


			WITH data AS ( SELECT PROVINCE, CODE FROM WI_KEYNOTE_RIVER_LAKE WHERE PROVINCE LIKE '%,%' ) SELECT
			REGEXP_SUBSTR( PROVINCE, '[^,]+', 1, LEVEL ) AS PROVINCE,
			CODE 
		FROM
			data CONNECT BY LEVEL <= LENGTH( PROVINCE ) - LENGTH( REPLACE ( PROVINCE, ',', '' ) ) + 1 
			AND PRIOR CODE = CODE 
			AND PRIOR SYS_GUID ( ) IS NOT NULL