How to display a number in words?

Oracle Apps Interview QuestionsCategory: SQLHow to display a number in words?
Questions Master asked 2 years ago
1 Answers
Shailender Thallam Staff answered 2 years ago

Below is the query with converts a number into words
SELECT sal, (TO_CHAR(to_date(sal,’j’), ‘jsp’)) FROM emp;