SQL - Table Function

About

PIPELINED functions (or table function) operate like a table and is a good workaround to Stored Procedures

They are useful if there is a need for a data source other than a table in a select statement.

Articles Related

Syntax

Without the table(…) wrapper

• Postgres:
• SQL Server- Table-Valued User-Defined Functions

With the table wrapper:

• Oracle
• DB2

Not implemented:

• mysql

Example with table wrapper:

SELECT W FROM tablefunc(a,b)