Skip to Main Content

E-Business Suite

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to increment a varchar field sequentially

User_H6M8AOct 9 2019 — edited Feb 9 2021

Hello gurus,

I have a column which has a value ASFDSFS00001

I need to increment the last digit to make it to the new value as ASFDSFS00002 then ASFDSFS00003 onwards

How to achieve this by extracting the last digit and increment the value by i.e

ASFDSFS00001

ASFDSFS00002

ASFDSFS00003

Comments

Post Details

Added on Oct 9 2019
2 comments
52 views