Packages Are the Foundation of Good PL/SQL Architecture Standalone procedures and functions have their place, but packages...
martin
The Problem You create a Dynamic Action to refresh a report region when a select list changes,...
Beyond One Row at a Time Many business workflows involve selecting multiple rows and performing an action:...
Common SQL Mistakes That Kill Performance These ten SQL antipatterns appear frequently in APEX applications and cause...
Security Before Go-Live Before deploying an APEX application to production, review this checklist of security settings and...
The Problem A page takes 5 to 15 seconds to load. Users complain. You are not sure...
Power Users Love Keyboards Adding keyboard shortcuts transforms a click-heavy web app into a productivity tool. Users...
When the Optimizer Needs Guidance Oracle’s cost-based optimizer (CBO) does an excellent job choosing execution plans for...
Zero-Code REST APIs ORDS AutoREST is the fastest way to expose database tables and views as REST...
Why Use EBS APIs Instead of Direct DML Oracle E-Business Suite stores data across thousands of tables...