SQL Developer

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 take last 7 digits from a varchar column

OraFighterJun 25 2014 — edited Jun 25 2014

How to take last 7 digits from a varchar2 colum

COL1

12345678

12345

1234567890123

1234567

Out put should be as below

COL1

2345678

12345

7890123

1234567

any built in function or any other way please

This post has been answered by Rob van den Berg on Jun 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2014

Added on Jun 25 2014

#sql-developer

6 comments

4,499 views