Skip to Main Content

SQL & PL/SQL

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!

Counting with letters instead of numbers

576958Sep 30 2009 — edited Oct 1 2009
hi everybody,

today I got the requirement to represent the rownums of a recordset (1, 2, 3, 4, 5 and so on) as letters (A, B, C, D, E and so on). First of all I thought there is a database function equal to the to_char function with RN parameter (which is able to convert numbers to roman numbers easily)... but I didn´t find anything.

So, is there a database function that I haven´t found yet or have you got some custom code for me to realize this?

ty in advance
- Oliver
This post has been answered by Frank Kulash on Sep 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2009
Added on Sep 30 2009
10 comments
4,304 views