SQL - Table Function

Data System Architecture

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.

Syntax

Without the table(…) wrapper

With the table wrapper:

Not implemented:

Example with table wrapper:

SELECT W FROM tablefunc(a,b)





Discover More
Relational Data Model
(Relation|Table) - Tabular data

A Relation is a logical data structure composed of tuple (row) attribute (column, field) The following data structure are a relation: a table, a materialized view (query) (store data) a query,...
Model Funny
Function - User Defined Functions (UDF)

User-defined_functionUser-defined Functions (UDFs) is a function provided by a developer and behave as a built-in function. It gives to the developer the possibility to enhance the function possibilities...
Card Puncher Data Processing
Oracle Database - Table Function (Pipelined)

table function (PIPELINED functions) in Oracle. Oracle9i introduces a family of new features to support more scalable and efficient ETL (Extraction, Transformation, Load) processing for data warehouses...



Share this page:
Follow us:
Task Runner