Click here to Skip to main content
15,879,095 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear All,

I have got a task in which I have to generate alphabet sequence on execution of the same oracle query every time.

When I execute a query first time, it has to generate A
When I execute the same query second time, it has to generate B.

So, it should generate A,B,C,D......Z

Once it reaches Z, it has to generate AA,AB,AC.....AZ

Kindly help me in composing a query or any suggestion would be appreciated.


What I have tried:

I have tried sequence generator by searching in Google but it is generating the sequence of all alphabets at the same time. But I need one by one alphabet on execution of the same query..
Updated 17-May-20 7:50am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900