SQL - Table Function

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)

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap