Archives

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.

Steven explores how to select not from a table or a view but a function. More specifically, from a table function.

The returning into clause is one of the best examples of the tight integration between SQL and PLSQL. Steven Feuerstein explains.

Steven dives into the PL/SQL function sqlerrm in this week's episode of Feuertips

In this episode of Feuertips, Steven talks about one very special and unusual PL/SQL package, called STANDARD.