Archives
Discover the essential steps for upgrading your Oracle APEX applications after you've deployed the latest version. Learn how to leverage new features, and ensure a smooth transition by following best practices, including reading release notes, backing up, refactoring code, and testing.
Read more
Anton Nielsen lays out Oracle database date-related datatypes we need to consider, and which to use when. You might be surprised.
Read more
SQL makes adding rows to a table easy. Just execute an insert statement! But there are several nuances to consider. Steven goes over them.
Read more
Steven and special guest Anton Nielsen talk about their favorite goodies in the #orclapex PL/SQL API. Much heavy lifting by APEX!
Read more
Steven's special guest Monika Lewandowska provides tips to organize PL/SQL code to make it deterministic while reducing unpleasant SQL!
Read more
When the Allowed Row Operations Column setting just doesn't cut it, check out Elisabeth's trick to make specific cells of your Interactive Grid read only.
Read more
In this week' Feuertip, Steven explores PL/SQL parameters and uncovers some interesting aspects you might not be aware of.
Read more
Steven dives into deterministic functions. What they are, why you'd use them, and how they're different from result cache functions.
Read more
An episode all about triggers. They can be amazing, but they can be abused and lead to unexpected behaviors. Steven drills down.
Read more