Archives
Learn how to generate a conditional compilation package so that your code uses the latest features in APEX APIs - and your own products!
Read more
Toon Koppelaars of Oracle's Real World Performance Team discusses the ORA-04068 error with Steven, and what to do if you get it.
Read more
Steven introduces invoker rights (AUTHID). Learn some essential differences between definer rights and invoker rights in the Oracle Database.
Read more
In this episode learn how to take advantage of the PL/SQL compiler's ability to suggest improvements by turning on compile-time warnings.
Read more
Steven uses the day before Thanksgiving to look back on his 30 years with PL/SQL and share some of the things he is most thankful for.
Read more
In this episode of Feuertips, Steven invites Chris Saxon back to #Feuertips to talk about polymorphic table functions.
Read more
Samuel Nitsche joins Steven for a lively conversation about the obstacles we face when testing our PL/SQL code.
Read more
Carelessly using the result cache can result in the delivery of dirty data. In this episode, Steven shows us how to avoid that.
Read more
The result cache is an Oracle Database feature that helps avoid unnecessary CPU consumption. Use it and help save the planet in the process!
Read more
Did you know you can execute dynamic PL/SQL? In this Feuertip, Steven offers some tips on writing and running dynamic PL/SQL blocks.
Read more