OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SOME DOUBT

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

SOME DOUBT [message #4468]

Thu, 12 December 2002 05:07

CHANDU
Messages: 23
Registered: March 2002

Junior Member

HELLO
IAM CHANDU, I WANT NUMBERS IN WORDS FORM
EX:- 25467 THIS IS A NO.
I WANT THIS NUMBER IN THE FORM : TWENTY FIVE THOUSAND FOUR HUNDRED AND SIXTY SAVEN.

THIS PROBLEM SOLVE WITH ANY QUERY.

Report message to a moderator

Re: SOME DOUBT [message #4469 is a reply to message #4468]

Thu, 12 December 2002 07:36

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

Senior Member
Account Moderator

SQL> ed
Wrote file afiedt.buf

  1* select to_char(to_date(25467,'J'),'JSP') from dual
SQL> /

TO_CHAR(TO_DATE(25467,'J'),'JSP')
---------------------------------------------
TWENTY-FIVE THOUSAND FOUR HUNDRED SIXTY-SEVEN

Report message to a moderator

Previous Topic:	dbms_output_put problem
Next Topic:	I want to store a err message in Log/Txt file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 08:43:52 CDT 2024