Inside Oracle APEX by Patrick Wolf

Number of displayed Records of Oracle APEX Popup LOV

Recently I answered a question about where to change the number of displayed records of a Popup LOV in Oracle APEX and I thought it could be of general interest. The behavior of Popup LOVs can be changed through the Popup Lov template. You can find it at Shared Components\Templates\Popup LOV. In the Pagination section you will find [...]

Continue reading...

Undocumented option for Static List of Values

Did you know that the STATIC and STATIC2 keyword used to define Static List of Values for Oracle Application Express (APEX) contains an undocumented option? The online help documents the usage with STATIC[2]:Display Value[;Return Value],Display Value[;Return Value] But what to do if one of your values contains the semi colon or the comma in the text? You will [...]

Continue reading...

Non navigable Date Picker-/Lov/Image Button Icons

I still remember my “usability experience” when I first tried out Oracle APEX and created a form with a Date Picker and a Lov and run the page afterwards. I had to click tab twice to go from a Date Picker or Lov item to the next item, because the Icon next to the field got [...]

Continue reading...