Skip to content

Latest commit

 

History

History
63 lines (32 loc) · 2.38 KB

File metadata and controls

63 lines (32 loc) · 2.38 KB

Oracle APEX Plug-In: Number Field with Decimal

It's a Number Field with Decimal Plugin In, which allow only Numeric Values and one DOT and Specified decimal value (2 or 4) in Number Field.

Demo Application: https://apex.oracle.com/pls/apex/f?p=113036:9999::BRANCH_TO_PAGE_ACCEPT::9999:P9999_APP_PAGE_REDIRECT:35

Prerequisite:

DB versions: 12.1.0.1,12.2.0.1,18.4.0.0,19.0.0.0.0,19.2.0.0.19,21.0.0.0.0,21.1.0.0.0,21.1.0.0.1

APEX versions 20.1.0.00.13,20.2.0.00.20,21.1.0

Installation:

Export plugin file "item_type_plugin_orclking_number_field.sql" from Source directory and import it into your application.

Steps to Achieve:

Step 1: Create a new blank page.

Step 2: Export plugin file "item_type_plugin_orclking_number_field.sql" from Source directory and import it into your application.

Navigation: Shared Components ==> Plug-ins ==> Import

image

Plugin will be listed under plug-ins bucket after successful installation.

image

Step 3: Create a region to the page. Region type should be Static Content.

image

Step 4: Create a item to the region. Change item type to "Number Field with Decimal [Plug-In]".

image

Step 5: In the Settings section you can choose some options. The image below shows all the available options.

image

Element Text Position - Position of the field value (Left/Right)

Min. Value - Specifies the minimum value allowed

Max. Value - Specifies the maximum value allowed

Digits - Specifies the decimal value allowed

Output:

Then you output would display like this,

image

That's it.

Happy APEXing!!!...

References:

https://docs.oracle.com/en/database/oracle/application-express/20.2/aeapi/GET_INPUT_NAME_FOR_PAGE_ITEM-Function.html#GUID-6E53D97A-0710-4203-9F20-8F4B2153A2E1