Display the number value in Words:-
------------------------------------------
The following query can be used to display the number in the words.
select 'Your Number', (to_char(to_date('Your Number','j'), 'jsp')) from dual;
Example:-
select 211, (to_char(to_date(211,'j'), 'jsp')) from dual;
Thanks to Chandra k Kadali for posting this Article.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment