Archives

Steven introduces invoker rights (AUTHID). Learn some essential differences between definer rights and invoker rights in the Oracle Database.

In this episode learn how to take advantage of the PL/SQL compiler's ability to suggest improvements by turning on compile-time warnings.

In this episode of Feuertips, Steven invites Chris Saxon back to #Feuertips to talk about polymorphic table functions.

Samuel Nitsche joins Steven for a lively conversation about the obstacles we face when testing our PL/SQL code.

Carelessly using the result cache can result in the delivery of dirty data. In this episode, Steven shows us how to avoid that.

The result cache is an Oracle Database feature that helps avoid unnecessary CPU consumption. Use it and help save the planet in the process!

Did you know you can execute dynamic PL/SQL? In this Feuertip, Steven offers some tips on writing and running dynamic PL/SQL blocks.

Continuing Steven's series on table functions, Chris Saxon of Oracle AskTOM fame drops by to talk about a fantastic, new Oracle Database feature: SQL macros.

Table functions are wonderful but "typical" tools. In this episode Steven explore a special, strange and delightful version of table functions, called pipelined table functions.