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 extract the string after a dash ?

3214887Apr 27 2016 — edited Apr 27 2016

The column values in a table look like as shown below.

2993833-4550045575-1005634032

3383911-ACTOE-1005966215

I need to extract the string after the last dash. So, the output should be displayed as

1005634032

1005966215

How do I get the string after the last dash ?

This post has been answered by CarlosDLG on Apr 27 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2016

Added on Apr 27 2016

12 comments

47,972 views