Skip to Main Content

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!

last 3 characters of a string

user12957777Oct 14 2011 — edited Oct 14 2011
How to get the last 3 characters of a string occuring after a character / alphabet  without using REGEXP_SUBSTR ? 

Ex: 10000A001 is the string.

Note: -  I want to use it in Oracle reports 6i, therefore i cannot use the statement REGEXP_SUBSTR 

Sanjay
This post has been answered by AndreyN on Oct 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2011
Added on Oct 14 2011
4 comments
16,850 views