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!

Get the last two three character in a string

463180Feb 1 2006 — edited Feb 2 2006
Hello Friends,
i have a column in a table and that table has variable character.the value may be of 4,5 6,7,8,9,10 characters.for me last 3 character is important.so can u tell me a way to capture the last3 character dynamically.

column
Asd
Gttgs
Dretee
Shfdjd

In this column i want only the last 3 character and show use it in othere work..

if any body have any suggestion,i will really admire


Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2006
Added on Feb 1 2006
3 comments
3,163 views