Archives
For me, Joel Kallman was first and foremost about giving, not taking. He was so generous with his time, his knowledge, his support, his encouragement. Which is why I like Joel Kallman Day so much, but also why I am so taken with the APEX community. Time and again,...
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
In this week' Feuertip, Steven explores PL/SQL parameters and uncovers some interesting aspects you might not be aware of.
Read moreSam Nitsche recently interviewed me for an article in the DOAG (German Oracle User Group) RedStack magazine. That was fun! You can find the entire article in English on Sam’s blog. I especially love the title Sam used for his post: Stop Hiding From Your Planet In any case,...
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
When should you commit changes in your PL/SQL code? When does PL/SQL itself perform commits for you on your behalf? Find out in this episode of Feuertips.
Read more
Cursor for loop is an example of #plsql's tight integration with #SQL, but it also presents opportunities for "bad lazy" coding. Steven explains
Read more