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;


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

Credit goes to and original article via Oracle Apps Training.

7 thoughts

  1. 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.


  2. It is working now please change the quotation mark

    select ‘&a’, (to_char(to_date(‘&a’,’j’), ‘jsp’)) from dual;


Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s