Re: Roman Numerals
From: Stephan Born <stephan.born_at_beusen.de>
Date: Fri, 01 Oct 1999 14:32:44 +0200
Message-ID: <37F4A9EC.2304F27F_at_beusen.de>
Date: Fri, 01 Oct 1999 14:32:44 +0200
Message-ID: <37F4A9EC.2304F27F_at_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 - 14:32:44 CEST