Archives
Introducing APEXd2d, a unique real-time problem-solving clinic, created for APEX developers by APEX developers.
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
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.
Read more
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.
Read more
Steven explores how to select not from a table or a view but a function. More specifically, from a table function.
Read more
The returning into clause is one of the best examples of the tight integration between SQL and PLSQL. Steven Feuerstein explains.
Read more
Steven dives into the PL/SQL function sqlerrm in this week's episode of Feuertips
Read more