How to do a dynamic seq count in Roman numerals? 1

[foru11]

Hi all,

I am using CR 10, Oracle 10g database.

I have use the Running Total to do a dynamic seqno count but it is in normal numeric form (1, 2, 3...). But user wants the seqno to be in Roman numerals form (I, II, III....). How can I do this?

Thanks in advanced for help.

 

[lbass]

How high do you have to go? You probably need to do a crosswalk like this:

select {#rt}
case 1 : "I"
case 2 : "II"
case 3 : "III"
case 4 : "IV"
case 5 : "V"

//etc.

-LB

 

[foru11]

Oh, it won't go to very high.

It works perfectly!! Thanks a lot LB.