SQL - Table Function

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - 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.


3 - Syntax

Without the table(…) wrapper

With the table wrapper:

Not implemented:

Example with table wrapper:

SELECT W FROM tablefunc(a,b)