How to convert number to words in oracle form 6i?

[Rohullah]

Hello

I want to convert emp table sal column to word form for every row in emp table.
how to do it.

iam traing this code but it doesnt work
i dont know why.

on when-new-form-instance event.
-----------------------------------

:emp.sal:=to_ch ar(to_date(:emp .sal,'j'),'jsp) ;

-----------------------------------

how to do it.
please send me the best answer;
thank u in advance.

[debasisdas]

try this

select to_char(to_date(sal,'j'),'jsp') into my_variable from emp;