send me answer for some function questions

[gurusuryas]

1.Function for displaying Rupees in Words.
2.Function for displaying Numbers in Words

[Guptha_S]

Hi gurusuryas

Try this

SQL> SELECT emp_id, emp_name, basic_salary, net_salary, (to_char(to_date(net_salary,'j'), 'jsp'))
FROM employee;

play around and make some small changes you can add "Rs." at the beginning and "only" at the end

Hope this helps
Regards

[gurusuryas]

Thanks Guptha for ur co opertaion