Monday, October 13, 2008

To Print Salary in words

select nameto_char(to_date(salary,'J'),'Jsp') from join;

2 comments:

iamjhkang said...

what's the nameto_char function?
is this built-in?
after which version?

Bernandas said...

No not an built-in. Typing mistake. Please consider the below query.

select to_char(to_date('10001','J'),'Jsp') from dual