Hi,
Is there a function that can conver number to word?
ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND
THREE. Thank you in advanced!!!
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see
some where I got this
create or replace
function spell_number( p_number in number )
return varchar2
as
type myArray is table of varchar2(255);
l_str myArray := myArray( '',
' thousand ', ' million ',
' billion ', ' trillion ',
' quadrillion ', ' quintillion ',
' sextillion ', '
You can find perl module doing that at:
http://www.bayview.com/software/perl.shtml
--
Mladen Gogala
Oracle DBA
-Original Message-
Andrea Oracle
Sent: Friday, August 22, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a function that can conver number to word?
I got this off of metalink:
select to_char( to_date( 1, 'J' ), 'jsp' ) from
dual;
SQLselect to_char( to_date( 123,'J'), 'jsp') from
dual;
TO_CHAR(TO_DATE(123,'J')
--
one hundred twenty-three
SQLselect to_char( to_date( 123,'J'), 'Jsp') from
dual;
SELECT TO_CHAR(TO_DATE(2003,'J'),'JSP') FROM DUAL;
TO_CHAR(TO_DATE(20
--
TWO THOUSAND THREE
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 22, 2003 4:19 PM
Hi,
Is there a function that can conver number to word?
-Original Message-
AK
Sent: Friday, August 22, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
some where I got this
create or replace
function spell_number( p_number in number )
return varchar2
.
.
.
That is the same routine i was directed to a few months back when I asked
03:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: convert number to word ???
I got this off of metalink:
select to_char( to_date( 1, 'J' ), 'jsp' ) from dual;
SQL select to_char( to_date( 123,'J'), 'jsp