how to changing number to word in oracle forms

[fariha]

dear
how to changing number to word in oracle developer? i have an attachment like this, i am beginner in oracle forms and this site also. Can any one please help me out from this problem.

[Kkshivanii]

if you want to change 500 in words
input = 500
output = FIVE HUNDERED/=

SELECT UPPER(TO_CHAR(T O_DATE(500,'J') ,'Jsp')) || '/=' AS new_value FROM dual;

[pritikumari]

I have written a very simple query which result a value 500, i need to convert this value like following:-

old value = 500

new value = FIVE HUNDERED/=

You can opt Oracle Training In Noida.