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!

How to get last portion of string using reg_exp

Ann 81Nov 21 2013 — edited Nov 21 2013

Hi,

I have a string like 'abcd,def,hijk,lmno,pqrs' always separated by comma. How to pick the last word after the last comma.

in this eg i need to get "pqrs" ,

I know with Reg_exp it will be easier but I tried in many ways I am not getting it . Can you help me

Thanks

Ann

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2013

Added on Nov 21 2013

2 comments

2,036 views