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;
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;
Leave a Reply
Want to join the discussion?Feel free to contribute!