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!

Cutting string on dots

RanieriOct 19 2009 — edited Oct 21 2009
Hello,

I have a string like "14.10.5.1.5" and I need to cut it on dots to have a return like

sequence | string
1 | 14
2 | 10
3 | 5
4 | 1
5 | 5

The number of dots can vary, so the string can be "14.10" or "14" or "14.2.5" and so on...

How could I solve it?
I appreciate any help

Thanks
This post has been answered by 21205 on Oct 19 2009
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2009
Added on Oct 19 2009
16 comments
644 views