Xref: alice comp.databases.oracle.misc:43194 comp.databases.oracle.tools:32865 Path: alice!news-feed.fnsi.net!feed.newsfeeds.com!newsfeeds.com!hermes.visi.com!news-out.visi.com!feed2.nntp.acc.ca!feed.nntp.acc.ca!news.ican.net!not-for-mail From: Hakan Eren Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc Subject: Re: Roman Numerals Date: Fri, 01 Oct 1999 09:27:11 -0400 Organization: ICAN.Net Customer Lines: 105 Message-ID: <37F4B6AF.A752EBE5@iprimus.ca> References: <37f48e63.0@145.227.194.253> Reply-To: nvc@iprimus.ca Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------1B59A245C06672350E616EBC" X-Mailer: Mozilla 4.61 [en] (Win98; U) X-Accept-Language: en,tr To: Mark G --------------1B59A245C06672350E616EBC Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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

--------------1B59A245C06672350E616EBC--