Hello, is there a way to increment a letter instead of a number?
Like if I have a document_rev_cd column that needs to be incremented to the next letter like:
'A' and then the next record will have 'B' and then 'C', etc.
Kind of like 1, 2, 3, 4
I am writing pl/sql code where it checks to see if there is a document_rev_cd exists and if it does,
then get that value and increment it to the next letter in the alphabet.
--check to see if document_rev_cd has a value
if length(document_rev_cd) >1 then
--increment the rev_cd to the next value or letter in the alphabet
document_rev_cd := --this would increment to 'B', if the document_rev_cd was 'A'