Oracle Database 23ai introduced a useful SQL improvement which is the ability to use a VALUES(…) clause as an inline table within a query. The problem You need a small, hardcoded set of rows, a handful of status codes, a reference list or some test data and ideally without creating a temporary table or a view so […]
Context You have a dynamic region that for whatever reason takes time for the data to be displayed. You have enabled lazy loading. Rather than solely rely on a busy spinner you would like to provide the user with more information. The existing application The user clicks the Next button Whilst the region is loading, […]
This post demonstrates data redaction using Oracle Transparent Sensitive Data Protection (TSDP). We’ll configure the HR Employee table so that salary data is visible only to users with the MGR role—all other users will see zero when querying this column. The example was developed using the Oracle Pre-Built Developer VMs for Oracle VM VirtualBox. Implementation […]
As of Oracle APEX 23 there still isn’t a built-in framework event for working with the Region Display Selector (RDS)—something I recently bumped into while trying to show a specific region only when the ‘Show All’ tab was active. When other tabs were selected, that region should be hidden. In this post, I’ll walk through […]
Building on the previous auto-refresh report example, this post shows how to let users change the interval when a report will be automatically refreshed. Prerequisites The example shown was built using Apex version 24.1.3. Goal This chart should automatically refresh every X seconds dependent on the value of the Refresh Interval Select List. Step 1 […]
iancarpenter.dev 
You must be logged in to post a comment.