SQL Query
SELECT REGEXP_SUBSTR('Kalai, Oracle, Developer, From, 2012','[^,]+', 1, LEVEL) "Row"
FROM DUAL
CONNECT BY REGEXP_SUBSTR('Kalai, Oracle, Developer, From, 2012', '[^,]+', 1, LEVEL) IS NOT NULL
Output
Row
------------
Kalai
Oracle
Developer
From
2012
No comments:
Post a Comment