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!

Format a number field so it displays leading zeros (i.e. 0001 instead of 1)

M.EmmanuelJun 12 2016 — edited Aug 28 2016

I have the following label item (P5_CAT_CODE):

When value is 1 I would like to get it displayed in the label box as 0001.

I tried to apply format mask without success:

As you can see retrieving the database value still displays '1' instead of '0001':

Any tips?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2016

Added on Jun 12 2016

#apex-discussions

5 comments

1,812 views