Archives

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.

In this blog, Steven proposes a refactoring exercise. Look at the code. What changes does it need? Discuss it with him on Feuertips June 16.

In this blog for episode 12 of Feuertips, Steve shows us how to suppress row-level errors in Oracle Database.

Naming conventions are key to writing high-quality code. Steven explores what motivates conventions to clarify what works best for us and why.

In this episode: to manipulate in-program data in set-kinda ways, use nested tables. They have cool, set-oriented features.

The WITH keyword lets us use modular design with SQL and helps avoid redundant logic in SQL statements. Learn more in this Feuertips episoide