Oracle 26ai introduces GROUP BY ALL — a shorthand that tells Oracle to automatically include every non-aggregate column from your SELECT list in the grouping, so you never have to enumerate them by hand. The problem Standard SQL requires every non-aggregate column in the SELECT list to appear explicitly in the GROUP BY clause. For […]
Oracle AI Database 26ai introduces the QUALIFY clause — a cleaner way to filter the results of analytic functions without a subquery or Common Table Expression (WITH clause). The problem Analytic functions such as RANK(), ROW_NUMBER(), and AVG() OVER (…) are evaluated after the WHERE clause. This means you cannot reference them directly in a […]
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 […]
iancarpenter.dev 
You must be logged in to post a comment.