decode numbers to words

[dvc]

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...

[julian]

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"?

[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?

[julian]

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.

[dvc]

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.

[csvenkata]

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

[dvc]

yes! that's the one. Is JSP your function?
can you share it?

[csvenkata]

No, JSP is not my function. It is Oracle's. Jsp-Julian date in spelled out format.
Rgrds
Venkat

[julian]

Thanks for the info! I didn't know that trick. It works on 8.1.7.

[dvc]

Thank you very much for giving the idea, Ven...