OraFAQ Forum: Reports & Discoverer » displaying amount in words

Home » Developer & Programmer » Reports & Discoverer » displaying amount in words

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

displaying amount in words [message #88209]

Mon, 06 May 2002 22:05

yram
Messages: 75
Registered: February 2001

Member

hi
I want to display my grand total in words(egs. 56 (fifty six)) in words in my report the 56 is nothing but my bill amount.

do help me immedialty

by
yram

Report message to a moderator

Re: displaying amount in words [message #88211 is a reply to message #88209]

Wed, 08 May 2002 20:43

Vinod Sangwan
Messages: 3
Registered: May 2002

Junior Member

Hi,
You can try following query.

select to_char(to_date('10','j'),'jsp') from dual;

Report message to a moderator

Re: displaying amount in words [message #88426 is a reply to message #88209]

Wed, 28 August 2002 02:14

Franklin
Messages: 4
Registered: July 2002

Junior Member

This program really good,

What i need is suppose i want form

500500.00 it should display five lakh and five hundradd
zero paise only..

Will it is possible if it is (pls send me the code for above)

Report message to a moderator

Previous Topic:	NEED HELP!!!!!!!!!! ORACLE REPORTS WANTED IN A DOC OR HTML FILE
Next Topic:	Oracle Applications 11i / Discoverer joins configuration and joins definitions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 04:42:20 CDT 2024