Re: Roman Numerals

Use Oracle built-in,

SQLWKS> SELECT TO_CHAR(8, 'RN') FROM DUAL
     2> /
TO_CHAR(8,'RN')
---------------
           VIII
1 row selected.
SQLWKS> SELECT TO_CHAR(1, 'RN') FROM DUAL
     2> /
TO_CHAR(1,'RN')
---------------
              I
1 row selected.
SQLWKS> SELECT TO_CHAR(3999, 'RN') FROM DUAL
     2> /
TO_CHAR(3999,'R
---------------
      MMMCMXCIX
1 row selected.
SQLWKS> SELECT TO_CHAR(0, 'RN') FROM DUAL
     2> /
TO_CHAR(0,'RN')
---------------
###############
1 row selected.
SQLWKS> SELECT TO_CHAR(4000, 'RN') FROM DUAL
     2> /
TO_CHAR(4000,'R
---------------
###############
1 row selected.

The number should be in [1..3999]

Hakan

Mark G wrote:

Hi,

Has anyone got a function to convert numbers to Roman Numerals?

eg  select roman(8) from dual (returns VIII)

Mark