Re: SQL Number to Text Conversion

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 28 Jan 2000 19:30:28 +0800
Message-ID: <38917DD4.36B2@yahoo.com>

Tom Verhagen wrote:
>
> works fine for numbers between ...
>
> ORA-01854: julian date must be between 1 and 5373484
>
> Erika Grondzakova wrote:
>
> > Hi,
> >
> > SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
> > FROM DUAL;
> >
> > HTH,
> >
> > Erika
> >
> > Colin Sheppard wrote:
> > >
> > > Hello,
> > >
> > > I was wondering if you can direct me to some ORACLE PL/SQL code/builtin
> > > function, or a web site that converts a numeric value into text, and/or
> > > vice-versa? For example:
> > >
> > > '2972'
> > >
> > > would be
> > >
> > > 'two thousand nine hundred and seventy two'
> > >
> > > Thank you for your kind attention and assistance,
> > >
> > > Cheers,
> > >
> > > Colin Sheppard,
> > > IT Solutions Specialist,
> > > Agilent Technologies,
> > > Singapore.

http://govt.oracle.com/~tkyte/Misc/SpellANumber.html --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 28 2000 - 05:30:28 CST