Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    1

    Unanswered: Spell number in string

    How to spell a number in string?

    Example: if the number is 99, then the string representation should be ninty nine

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    see the following link

    Ask Tom "Spell the number"
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Sep 2012
    Posts
    18
    select to_char(TO_DATE(5000,'j'),'JSP') from dual;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •