Re: Roman Numerals

From: Stephan Born <stephan.born_at_beusen.de>
Date: Fri, 01 Oct 1999 14:32:44 +0200
Message-ID: <37F4A9EC.2304F27F@beusen.de>

Mark G schrieb:

> Hi,
>
> Has anyone got a function to convert numbers to Roman Numerals?
>
> eg select roman(8) from dual (returns VIII)
>
> Mark

select to_char(8, 'RN') from dual /* uppercase */ select to_char(8, 'rn') from dual /* lowercase */

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------

Received on Fri Oct 01 1999 - 07:32:44 CDT