select * from (
with t as (select 'A-INSTALL,6-FOLLOWUP' str from dual)
SELECT trim(REGEXP_SUBSTR (str,'[^,]+' ,1,level))
FROM t
connect by instr(str, ',', 1, level - 1) > 0
and connect_by_root str = str)
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
This blog has been created for general blather on Oracle Application.
This post helps you splitting two rows into multi rows. This operation is very important to know since it helps in large applications. The code for the operation is easy to learn and implement. I am really impressed with the work of your blog.
ReplyDelete