Re: Roman Numerals

From: Hakan Eren <nvc_at_iprimus.ca>
Date: Fri, 01 Oct 1999 09:27:11 -0400
Message-ID: <37F4B6AF.A752EBE5@iprimus.ca>

Hi,

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
Received on Fri Oct 01 1999 - 08:27:11 CDT