The following paragraph is quoted from the chapter on changed behaviour within the Oracle APEX 26.1 Release notes The existing Static ID property for Regions, Buttons, Interactive Grid, and Interactive Report Columns is renamed to HTML DOM ID to better reflect its purpose in the DOM and to avoid overlapping with the newly-introduced Static ID used in APEXlang application exports. Acknowledgements Thanks to […]
Oracle 26ai introduces the FILTER clause, which lets you apply a WHERE condition directly inside an aggregate function, replacing the CASE workaround. If you want to follow along Add a new column to the HR.EMPLOYEES table called STATUS update some of the records to INACTIVE and the rest to ACTIVE. A script to make these […]
Oracle 26ai adds the OLD keyword to the existing RETURNING clause complementing the NEW keyword that was already there, and letting you capture both the before and after state of a row in a single atomic DML operation, with no extra SELECT required. The problem Audit logging, change tracking, and before/after comparisons all need both the old and new value of a column. […]
Oracle 26ai introduces GROUP BY ALL which is syntactic sugar to tell Oracle to automatically include every non-aggregate column from your SELECT list in the grouping, so you don’t have add them again in the GROUP BY clause. The problem Standard SQL requires every non-aggregate column in the SELECT list to appear explicitly in the […]
Oracle AI Database 26ai introduces the QUALIFY clause which is 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 […]
iancarpenter.dev 
You must be logged in to post a comment.