You are html tracking Visitor

Saturday, May 30, 2009

Display the number value in Words

Display the number value in Words:-
------------------------------------------

The following query can be used to display the number in the words.

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

Example:-

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

Thanks to Chandra k Kadali for posting this Article.

No comments: