Results 1 to 2 of 2

Thread: Try this: Number to Words Conversion

  1. 12-11-2007 #1
    sreekumar_nair_it
    sreekumar_nair_it is offline
    Contributing Member
    Join Date
    Nov 2007
    Answers
    53

    Try this: Number to Words Conversion

    Dear All,

    Spell out numbers to words

    select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
    decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
    from dual

    Have a pleasant time



    Reply With Quote Reply With Quote
  2. 12-12-2007 #2
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas Try this: Number to Words Conversion

    Re: Try this: Number to Words Conversion

    what about using the following only.
    Code:
    select to_char(to_date(&num,'j')'jsp') from dual


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact