DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: decode numbers to words

  1. #1
    Join Date
    Jul 2001
    Posts
    45
    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...

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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"?


  3. #3
    Join Date
    Jul 2001
    Posts
    45
    I want to decode the amount in a table
    say 111.11 to "One Hundred Eleven Dollars and Eleven Cents". Had someone done this?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.


  5. #5
    Join Date
    Jul 2001
    Posts
    45
    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.

  6. #6
    Join Date
    Dec 2000
    Posts
    19

    Thumbs up

    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

  7. #7
    Join Date
    Jul 2001
    Posts
    45
    yes! that's the one. Is JSP your function?
    can you share it?

  8. #8
    Join Date
    Dec 2000
    Posts
    19
    No, JSP is not my function. It is Oracle's. Jsp-Julian date in spelled out format.
    Rgrds
    Venkat

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Thanks for the info! I didn't know that trick. It works on 8.1.7.

  10. #10
    Join Date
    Jul 2001
    Posts
    45
    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
  •  


Click Here to Expand Forum to Full Width