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 […]
VS Code’s Copilot-powered commit message generator is a powerful tool. In this post, I’ll walk through how to enhance its output to better reflect your team’s conventions and make your commits more consistent. The commit message before I have just added a new Unit Test to my Go project and select the “Generate Commit Messages […]
iancarpenter.dev 
You must be logged in to post a comment.