Display the number value in Words?

This query works only for the numbers between 1 and 5373484. What should we do if the number is out of this range?

what do u mean by 'JSP' & why to_Date for  a number ??

Hi Kiran,

Here the 'j' used as a format in to_date function return the number in julian year.Whereas the 'jsp' used in to_char made the julian year spelled out.

i.e. j-julian year and sp-spelling so jsp.

Bye....

Hi Phani Josyula

I think we cannot retrive numbers in words using a single querry other than julian option.... but we can create a function for this conversion ...

If any one knows another way of conversion using querry other than julian plz send me...

This query will also work,suppose if we want to convert 1920 into words,the query is select to_char(to_date(translate(1920,'1','1'),'j'),'jsp') from dual

HEY ALL,

Try out Using Array...

Tanx,

Nikhil

In order to display the number values , the best it can be done is with the julian i.e. j and jsp.

however, using the translate also returns the same value for whatever value to display.

select to_char(to_date(1920,'j'),'jsp') from dual;

This answer is no different to
select to_char(to_date(1290,j),jsp) from dual;

Can we convert a number in words without using direct function/method?