Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg : Replace comma with Newline

915396Jan 9 2013 — edited Jan 10 2013
Hi Experts,

I'm a little confused and stuck up with this... Tried a lot but not able to get it properly.
Any help is highly appreciated... TIA.
-- "Input"
with xx as(
    select 'x,a,(b,c),(d,e),f,g' x
    from dual
)
select * from xx;

-- "Expected Output"
x
a
(b,c)
(d,e)
f
g
Database version : Oracle 10.2

Ranit B.
This post has been answered by chris227 on Jan 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 9 2013
23 comments
7,252 views