Musings on Oracle Database

Joining to a pipelined table function and “left correlation”

A pipelined table function may be called from regular SQL using the TABLE collection expression, e.g.

SELECT *
FROM TABLE(my_pipelined_function('ABC','DEF'));

where ‘ABC’ and ‘DEF’ are the inputs to the function.

What if you want to call the function repeatedly for several sets of inputs, e.g. testing the function for a variety of values? If those inputs are stored in a table somewhere, it ought to be as easy as doing a cross join to the table.