[Oracle] Split쿼리 예제

SELECT	SUBSTR(
				WDATA, 
				INSTR(WDATA, '|', 1, LEVEL) + 1, 
				INSTR(WDATA, '|', 1, LEVEL + 1) - INSTR(WDATA, '|', 1, LEVEL) - 1
			) NAME 
FROM 	( 
		 	SELECT	'|aaa|bbb|ccc|ddd|eee|'  AS WDATA
			FROM	dual
		) 
CONNECT BY LEVEL <= LENGTH(WDATA) - LENGTH(REPLACE(WDATA, '|')) - 1 

결과