How can i spellout the number. but the number like $24 and output will be twenty four doller

Interview Candidate
Aug 8th, 2006
4
1759

First
Prev
Next
Last

Showing Answers 1 - 4 of 4 Answers

Kranthi Reddy

Oct 6th, 2006

Please find the sample below.
select 24||'$',
       decode (substr('24$',1,1),1,'One',2,'Two',3,'Three',4,'Four','Others')||
       decode (substr('24$',2,1),1,'One',2,'Two',3,'Three',4,'Four','Others')||
       decode (substr('24$',3,1),'$','Doller','Others')
from dual;
I presume that it could be more dynamic than this with a little bit of effort.