Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number format mask horror

899274Nov 9 2011 — edited Nov 10 2011
Hi there. I'm having trouble with the number formatting in my interactive reports. NLS_TERRITORY is set to GERMANY, NLS_LANGUAGE to GERMAN. However, the default number formatting is wrong. If the integral part of a number is zero but the fractional part is not, the zero before the separator is not printed. For instance 0.34 would appear as ",34" instead of "0,34". I know this is customary in English, in German, however, it's not. I'm wondering why there is an application date format setting but no application number format setting. That would have been really helpful right now. How can I set a new number format which will be applied everywhere in my application? Is it possible?

In any event, what format mask do I have to use? I'm trying to reproduce the default behavior and add the missing zero, but I just can't get it to work. The problem is: whatever format mask I use, it only prints a fixed number of decimal places. The default prints only the relevant decimal places i.e. no trailing zeros. I tried for instance 990D999999, but then I get trailing zeros. I searched the web, I searched the docs, I tried lots of different format masks, nothing yields the desired result... I hope someone can help me. I'm using Apex 3.2.1 by the way. Thanks for your input in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2011
Added on Nov 9 2011
1 comment
520 views