Home » Infrastructure » Windows » Report Format length (Windows XP)
Report Format length [message #339323] Thu, 07 August 2008 05:07 Go to next message
amit_kiran
Messages: 50
Registered: July 2006
Location: UK
Member
Hi,

Can you please help me in this matter?

I am currently generating report from Oracle data.

COLUMN "Voucher Amount" heading "Voucher|Amount" FORMAT 9999.99

Output of this report gives me a length of 8 characters. If there is an amount of 250 the output is displayed ' 250.00'. Total length is 8 characters.

Can you please let me know if there is any way to format this numeric field to 7 digits?

Thank You very much.
Amit.
Re: Report Format length [message #339342 is a reply to message #339323] Thu, 07 August 2008 05:36 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not without "Column" command without removing one "9".
You have to use TO_CHAR in your queries.

Regards
Michel
Previous Topic: Batch File Parameters
Next Topic: oracle 10g install on windows 64 bit
Goto Forum:
  


Current Time: Thu Mar 28 09:50:36 CDT 2024