Re: SQL Number to Text Conversion

I can't resist...
look on the bright side, at least it gave the same answer... ;-)
cindy

Leo Van Nieuwenhuyse wrote:

> Works only in ENGLISH!
> SQL> SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
> 2 FROM DUAL;
>
> TO_CHAR(TO_DATE(2972,'J'),'JSP')
> -------------------------------------
> TWO THOUSAND NINE HUNDRED SEVENTY-TWO
>
> SQL> alter session set nls_language = 'DUTCH';
>
> Sessie is gewijzigd.
>
> SQL> SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
> 2 FROM DUAL;
>
> TO_CHAR(TO_DATE(2972,'J'),'JSP')
> -------------------------------------
> TWO THOUSAND NINE HUNDRED SEVENTY-TWO
>
> SQL>
>
> Erika Grondzakova <Erika.Grondzakova_at_cern.ch> schreef in berichtnieuws
> 38916F58.E8D54803_at_cern.ch...
> > 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.
Received on Sat Jan 29 2000 - 00:00:00 CST