An example of how to use polymorphic table functions in 18c to dynamically convert CSV data to colum...

This PTF returns all the columns in the input table tab, and adds to it the columns listed in cols b...

An example of how to use polymorphic table functions to dynamically evaluate formulas. This solutio...

PTF's accept variables for use during parse or execution. This included scalar datatypes and PTF spe...

An example of using a polymorphic table function (PTF) to transpose columns to rows

Setup of data and demo packages and PTF simple function code.

CSTORE for Compile State (DESCRIBE) and XSTORE for Execution State (OPEN,FETCH_ROWS and CLOSE.

The skip_col PTF returns all the columns in a table except the columns specified in the PTF input ar...

The to_doc Polymorphic Table Function (PTF) example combines a list of specified columns into a sing...

The stack PTF example unpivots the non-null values of the specified numeric columns by converting ea...

The noop PTF returns the input rows as the output rows without any modification or filtering. Noop i...

A Polymorphic Table Function to split the first column of a table using ; as a separator

Examples of how to omit columns from queries using polymorphic table functions and SQL macros. Se...

Polymorphic Table Functions (PTFs) Interrogate what they are passed

Add and populate columns

PTF's can throw exceptions. This script demonstrates when they will (and when they wont) pass to a c...

PTF's have a row replication feature to add rows to result sets as required.

Introduce GET_ROW_SET

The row_num PTF example appends a sequence column to a table.

Interrogate fetched row set to populate added column

This example creates a Polymorphic Table Function (PTF) that replicates each input row by the replic...

PTFs can add column to the output.

A Polymorphic Table Function to split an arbitrary column of a table using an arbitrary separator

Tracing table polymorphic

Introduce table polymorphism

A Polymorphic Table Function to split an arbitrary column of a table using ; as a separator

Add columns and replicate rows

Row replication

The split Polymorphic Table Function (PTF) example splits each row of the input table into specified...

The rand_col PTF appends specified number of random-valued columns to the output.

This example shows how to change the default method name of the noop_p polymorphic table function (...

Details of ROW_SET_T