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!

How to format and validate percent value

Soukaina IDRISSIMar 8 2018 — edited Mar 21 2018

Hi everyone,

I have one item named, P1_PERCENT: which represents a percentage.
I want to know how can i validate this field, knowing that, it should be:

  • Numeric (Integer or Decimal)
  • Positive
  • Between 0 and 100

I used a Format Number plugin to format this field, but i dont know how can i restrict the entry of values between 0 < val < 100

I already did demonstration of this problem, on apex.oracle.com with this credentials:

Workspace: ws_formation

Username: asoukaina

Password: s@boulah1013

I used the Application 103863 - Input Validation

Thank you for help.

This post has been answered by Mint-Innit on Mar 8 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2018
Added on Mar 8 2018
7 comments
1,156 views