OraFAQ Forum: SQL & PL/SQL » procedure which convert amount in digits to in word

Home » SQL & PL/SQL » SQL & PL/SQL » procedure which convert amount in digits to in word

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

procedure which convert amount in digits to in word [message #39492]

Fri, 19 July 2002 08:13

aditya
Messages: 36
Registered: March 2001

Member

hello all
i want to write a procedure which convert amount in digits to in words like 1,150 should be converted in to "ONE THOUSAND ONE HUNDRED FIFTY" plz help me
AD

Report message to a moderator

Re: procedure which convert amount in digits to in word [message #39496 is a reply to message #39492]

Fri, 19 July 2002 08:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Wrap this into a procedure

SQL>  select ename,sal,TO_CHAR(TO_DATE(sal, 'J'), 'JSP') inWords from emp;

ENAME             SAL INWORDS
---------- ---------- ------------------------------------------------------------------------------
SMITH
ALLEN            1600 ONE THOUSAND SIX HUNDRED
WARD             1250 ONE THOUSAND TWO HUNDRED FIFTY
JONES            2975 TWO THOUSAND NINE HUNDRED SEVENTY-FIVE
MARTIN           1250 ONE THOUSAND TWO HUNDRED FIFTY
BLAKE            2850 TWO THOUSAND EIGHT HUNDRED FIFTY
CLARK            2450 TWO THOUSAND FOUR HUNDRED FIFTY
SCOTT            3000 THREE THOUSAND
KING             5000 FIVE THOUSAND
TURNER           1500 ONE THOUSAND FIVE HUNDRED
ADAMS            1100 ONE THOUSAND ONE HUNDRED
JAMES             950 NINE HUNDRED FIFTY
FORD             3000 THREE THOUSAND
MILLER           1300 ONE THOUSAND THREE HUNDRED

Report message to a moderator

Re: procedure which convert amount in digits to in word [message #39542 is a reply to message #39492]

Mon, 22 July 2002 23:43

saravanan
Messages: 70
Registered: October 2000

Member

hai
try this
begin
dbms_output.put_line(to_char(to_date(&e,'J'),'jsp'));
end;

j stands for julian date
e ur input

Report message to a moderator

Previous Topic:	Duplicate rows
Next Topic:	How to return a recordset from procedure w/o temp table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 21:33:20 CDT 2024