Display the number value in Words:-
——————————————
The following query can be used to display the number in the words.
select ‘&a’, (to_char(to_date(‘&a’,’j’), ‘jsp’)) from dual;
Example:-
select 211, (to_char(to_date(211,’j’), ‘jsp’)) from dual;
Credit goes to and original article via Oracle Apps Training.
Know-Oracle 
Absolutely Fantastic
LikeLike
Shiv ….
For digits as 21111111 it gives
ORA-01830: date format picture ends before converting entire input string
Seems to_date cannot find more than 7 digits.
LikeLike
nice guys!!!!
very good oracle apps
LikeLike
nice man!!!!!
is there any library of oracle application?
LikeLike
It is working now please change the quotation mark
Eg..
select ‘&a’, (to_char(to_date(‘&a’,’j’), ‘jsp’)) from dual;
LikeLike
This query is not working,is there some thing to do with DB setup for ' .It gives as Invalid character.
LikeLike