Search for a command to run...
Check my first impressions of some of the most exciting new features in APEX 22.2
Creating apps built with ❤️ using Oracle APEX. PL/SQL dev. Exploring the AI and ML world. Keen on front-end, visual arts and new technologies. Love travel, sports, photography.
No comments yet. Be the first to comment.
Impressions from APEX Alpe Adria 2026
The Use Case Oracle APEX has a special template for Dialog Pages, called Drawer. This template is also available for any Region on you Page (this time called Inline Drawer). 💡 A Drawer is an overlay
The Use case (and the issue) What you see on this screenshot is a pretty common requirement in an APEX application - A form, where you have some text item or dropdown menu, followed by a button or som
The power of Claude Code - offline, free, secure
Using a REST Media Resource as an image source
After having gone through some of the APEX 22.2 new features in details, here I will share with you some others that would greatly improve the developer experience in first place. My reviews so far of the APEX 22.2 new features:
🔗 A glimpse of the APEX 22.2 new features - Device Geolocation
🔗 A glimpse of the APEX 22.2 new features - Vector Map tiles
🔗 A glimpse of the APEX 22.2 new features - Autocomplete
🔗 Make your app stand out using Meta Tags - better SEO and shareability
You can now specify a custom name for your True or False actions, enabling you to remove the guesswork from selecting the right action within Page Designer.
View the original idea request in the APEX Ideas App.
Built upon request from the APEX community, this feature is really helpful when you have a big number of Dynamic Actions, each having a big number of True/False Actions. Prior to that version, you had to go through each of them to see what they actually do in case you wanted some logic being changed. It happen a lot faster now just naming them and going through the list. And to illustrate that, here is an example of a Dynamic Action with multiple True actions in 22.1 and 22.2:
In addition, each Action is now having its own icon, which makes it even easier to visually recognise the Action Type. Good job, APEX team!
Support easier number entry on smartphones and tablets with the new Virtual Keyboard attributes.
Just like the Text Field with Autocomplete it has some improvements. One of them, adding the Row CSS Classes option, other one - adding inputmode="decimal" property to the input HTML element, so that it automatically displays a numeric keyboard when used on mobile device.
Louis Moreaux saw that need and added this recommendation in early September to his blog post on Improving APEX mobile applications.
You can now use Template Directives in HTML Expressions of Classic and Interactive Report columns, enabling you to remove conditional output logic from your SQL queries.
🔗 Learn more about
Template Directives🔗 Also check Jon Dixon's blog post on
Template Directives.
One of my personal favourites. For a long time, the only options to format Report data with some custom HTML was to do it directly in the select statement or to create a custom Template in Shared Components.
Having the Template Directives tackled that and I am using it whenever possible. Here is an example:
{case SOURCE/}
{when strava/}
<img width="28px" alt="#SOURCE#" title="#SOURCE#" src="#APP_IMAGES#icons/strava_logo_64_64.png">
{when fitness_challenge_app/}
<img width="28px" alt="#SOURCE#" title="#SOURCE#" src="#APP_IMAGES#icons/app_icon_64_64.png">
{otherwise/}
<span>#SOURCE#</span>
{endcase/}
What this template does is check the value of my Report SOURCE column and applies different HTML based on the value.
The benefit is that your Report SQL query still looks pretty, and at the same time you have the conditional output on your page.
Let's hope Template Directives continue to be supported in more and more APEX components!
Here is the most important you need to know regarding the use of CLOBs in the new version of APES:
VARCHAR2 data type was used to store the values.VARCHAR2 and CLOB datatype. This happens in the new attribute group Session State of your item settings 
Text Area, Display Only, Hidden, Rich Text Editor, Markdown Editor and Plugin editorAPEX_SESSION_STATE. It is used for getting and setting Session State values.🔗 Read the Official Oracle Documentation
🔗 To learn more about the new features, watch the official release videos.
Liked that post? Follow me on Twitter and LinkedIn!
🔷 @plamen_9 on Twitter
🔷 Plamen Mushkov on LinkedIn