-
Hi Friends,
I've read it here before a sql*plus program that decodes
numbers to words. I've searched all topics in this forums
but I can't find it anymore. Can somebody help me please...
-
Originally posted by dvc
I've read it here before a sql*plus program that decodes
numbers to words.
Could you be more specific, how should I understand "decodes numbers to words"?
-
I want to decode the amount in a table
say 111.11 to "One Hundred Eleven Dollars and Eleven Cents". Had someone done this?
-
Originally posted by dvc
I want to decode the amount in a table
say 111.11 to "One Hundred Eleven Dollars and Eleven Cents". Had someone done this?
:-) I could suggest at most this:
SQL> select to_char(111.11,'$99999.99') "Char" from dual;
Char
----------
$111.11
1 row selected.
-
patawa ka naman (thanks julian for being
attentive to my question)
Actually I want to develop a oracle report program
that prints checks. The requirement is that
the amount will also be printed in words.
-
Hi Hope u r looking for this
SQL>select to_char(to_date(111,'jsp'),'jsp') from dual;
TO_CHAR(TO_DATE(11
------------------
one hundred eleven
HTH
Regards
Venkat
-
yes! that's the one. Is JSP your function?
can you share it?
-
No, JSP is not my function. It is Oracle's. Jsp-Julian date in spelled out format.
Rgrds
Venkat
-
Thanks for the info! I didn't know that trick. It works on 8.1.7.
-
Thank you very much for giving the idea, Ven...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|