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!

Split String "100,1,29000,123,5678," into Number.

879879Nov 15 2012 — edited Nov 16 2012

There is a varchar2 column that contains data like this
*100,1,29000,123,5678,*

I really have no idea how to get each number.
100
1
29000
...

Could anyone please suggest me?

Thank you,
Fah

This post has been answered by Purvesh K on Nov 15 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2012

Added on Nov 15 2012

#query, #sql

6 comments

376 views