Archives

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.

When invoking procedures and functions, you can specify arguments for parameters in two different ways: positional and named. In this Feuertip, I will explore the benefits of named notation, aka, =>.

#sqlcode returns the current error code. Ah, but that simple functionality can hide so many interesting little facts.

In this episode, Steven dives into the challenge of handling exceptions that occur when you run a forall statement.

Collections are PL/SQL's version of arrays. Steven talks about ways you can, should, shouldn't iterate through the contents of collections.