,

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;
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply