오라클 문자열 split 하기
SELECT SUBSTR ('홍길동#과장#IT',
(SELECT INSTR ('홍길동#과장#IT', '#') FROM DUAL) + 1,
(SELECT INSTR ('홍길동#과장#IT', '#', 1, 2) FROM DUAL) - ((SELECT INSTR ('홍길동#과장#IT', '#', 1, 1) FROM DUAL) + 1)
) AS RESULT
FROM DUAL
반응형
댓글