Skip to Main Content
Forums

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!

Display a retrieved number with leading zeros in a form

M.EmmanuelAug 28 2016 — edited Aug 28 2016

I have a page which retrieves a number field.

When the number is 100 I got 100 -as expected-:

pastedImage_0.png

I know that I can use LPAD function to pad with zeroes to the left for strings, but as this is a number I am not sure on how to proceed.

I would like the field to display 0100 instead of 100:

The item is numeric:

pastedImage_2.png

I have tried to select a 0000 format mask in the item:

pastedImage_1.png

Any tips? Can someone help?

APEX 5.0.3.00.03

Universal Theme

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2016
Added on Aug 28 2016
#apex-discussions
5 comments
1,411 views