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!

How to get a substring by searching from the right side of the string?

Stanley Lee-OracleAug 5 2011 — edited Aug 5 2011
Hi,

I would like to just get the right parameter of this value.

'product (xyz) - abc' => get only 'abc' and get 'product (xyz)'.

There maybe cases where there area additional '-' and I would like to just get the first last instance of '-'.

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2011
Added on Aug 5 2011
4 comments
238 views