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!

Seperate string and number from a string

Xiaoyao LiJun 3 2011 — edited Aug 15 2011
HI,

I have strings like "AB123456", "CDE12345", "ABCD987"( both characterhs and numbers with different length), and need to seperate the characters and numbers, is that possible and how?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2011
Added on Jun 3 2011
13 comments
1,940 views