I want to generate a range of auto-incremented characters between two alphanumeric values. For example, AA to BA...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
should generate AA, AB, AC, AD,...BA. Your help in this regard is highly appreciated.
First of all, these aren't going to be "auto"-incremented. If you're hoping to have the database generate these codes automatically, it's not going to happen. The best you can do is generate these codes yourself. Start by creating a LETTERS table:
create table letters ( letter char(1) not null primary key ); insert into letters values ('A'),('B'),('C'),('D'),('E'),('F'),('G') ,('H'),('I'),('J'),('K'),('L'),('M'),('N') ,('O'),('P'),('Q'),('R'),('S'),('T'),('U') ,('V'),('W'),('X'),('Y'),('Z');
Now you can easily generate any range of codes like this:
select t1.letter||t2.letter from letters as t1 cross join letters as t2 where t1.letter||t2.letter between 'AA' and 'BA'
Dig Deeper on Oracle and SQL
Related Q&A from Rudy Limeback
Read about the Mimer Validator, a tool used to verify your SQL code, in this tip from SQL expert Rudy Limeback.continue reading
Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clausecontinue reading
Read an example of an SQL case expression from our SQL expert Rudy Limeback.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.