Re: HELP ABOUT REMAINDER IN PL/SQL

From: Conan <conan_at_(no-spam)as-if.com>
Date: Fri, 17 Nov 2000 08:49:13 -0000
Message-ID: <vi6R5.16573$Bw1.9631@news.indigo.ie>

Hi Andrew,
firstly to get a remainer in SQL or PLSQL use the MOD function. The syntax is mod(m,n) which gives the remainder of m when divided by N. as regards your assignment a quick way to convert a number to words is the use to_char(to_date(num,'J'),'Jsp') which converts the number to a date using Julian days and then spells it. The problem with this is that it will not give you the 'ands' as in One Hundred and Two. So you may need to write your own function.

HTH
Conan Received on Fri Nov 17 2000 - 02:49:13 CST