How to use the Oracle APEX Data Generator/Blueprints feature purely from SQL and how to make it convenient with SQL Macros.
Quickly access the APEX documentation, icons, CSS, and more from your spotlight search.
Find out what's behind the region-only type, Slots and selection support. Read about my first impression of APEX 24.1 in the end.
Learn how to add a global search to your Oracle APEX app that searches through all your data and navigation entries.
Give back to the community by contributing to open-source Oracle APEX Plug-ins with Git and GitHub.
A preview version of Oracle APEX 23.2 just got released on apex.oracle.com. Let's take a look at the new workflow feature.
Web Components make it easy to create custom JavaScript-heavy components and integrate well into Oracle APEX.
View Transitions allow you to animate page transitions. This makes the UI more polished and engaging.
Share your Template Components with the community and win great prizes.
APEX Text Messages is a powerful feature to organize reusable and translatable text fragments. You can use them in PL/SQL, JavaScript, and Substitution Strings.
I released the third beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
The most exciting feature in APEX 23.1 for me is Template Components. Find out what they are and how to use them.
How to create anchored popups in Oracle APEX that are positioned close to the button that triggers it. They offer a nice UX for quick data input.
Second beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
APEX_T_VARCHAR2 is a database type that comes with an Oracle APEX installation. I use it quite frequently and think that with it you can write better code.
APEX 22.1 changed a lot to the actions interface and added a new method with which we can call them easily from links.
Maps (not cartography but the data store) are a powerful tool for storing and accessing data in memory. In Oracle PL/SQL they are available too under the name Associative Arrays.
I made an Oracle APEX Plug-In that allows creating Slideover regions which slide in content from the side when opened.
Don't just hide Buttons when only some privileged users should be able to execute processes in Oracle APEX. With some JS you can still trigger them. Additionally use the read-only functionality where possible.
Great News: APEX 20.2 is finally out and adds a Dropzone component. For me, it does not look as intuitive as the Plug-In did, so I tried to improve the UX of it with a few lines of CSS.
If you use sequences to generate primary key values make sure you use the checksum feature of APEX. Otherwise, users can easily discover data they should not be able to see by raising or lowering the numeric ID in the URL.
Tables make it hard to give hierarchy to data. To underline the importance of certain values in a table you can use chips that highlight the values with colors.
I want to share a little script I wrote which generates a DML scripts for blob values like images. The output script can be used in your schema install script with your other master data.
