Motivation In my last post I described how to improve maintainability of routines using named parameter invocation . Named parameter invocation made it easier to keep the many parameters of routines organized with out messing up the order. Another way to make a routine invocation easier to read is by reducing the number of arguments I have to specify in the first place. Let's go back to to that same example. To underline that routines comprise procedures as well as functions I use an inline function this time.
CREATE OR REPLACE FUNCTION... [More]