Skip to Main Content

Breadcrumb

Search

Area

Category

Types

All

Tutorials

Scripts

Sort By

Date Added

Executions

Name

Likes

Results Per Page

Get Started with Table Functions 1: Overview

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module of...

Tutorial table function

57 5,047

4.1 years ago Steven Feuerstein (Oracle)
Get Started with Table Functions 4: Pipelined Table Functions

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". Pipelined tabl...

Tutorial pipelined table function

19 1,323

4.1 years ago Steven Feuerstein (Oracle)
Get Started with Table Functions 2: Returning Multiple Columns

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module sh...

Tutorial table function

20 1,235

4.1 years ago Steven Feuerstein (Oracle)
Get Started with Table Functions 3: Streaming Table Functions

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module sh...

Tutorial

14 494

4.1 years ago Steven Feuerstein (Oracle)
Dynamic CSV to Columns Converter: Polymorphic Table Function Example

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

Script 18c, polymorphic table functions

10 64

4.4 years ago Chris Saxon (Oracle)
Simple Table Function Example: Collection of Scalars

A table function is a function executed with the TABLE operator, and then within the FROM clause of ...

Script table function

1 41

6.2 years ago Steven Feuerstein (Oracle)
Table Functions and Ref Cursors

DML in a table function with a REF CURSOR as a parameter. Thats a lot going on.

Script Table Functions PLSQL REF Cursor PARALLEL_ENABLE

6 39

5.7 years ago Darryl Hurley
18c Echo Polymorphic Table Function

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

Script 18c ARPLS

2 35

4.3 years ago Oracle
Dynamic Pivot Polymorphic Table Function

A PTF which implements a dynamic pivot. Pass it a table, the column you want to pivot on, and a ...

Script 18c, polymorphic table functions

4 34

3.5 years ago Chris Saxon (Oracle)
Dynamic formula evaluation using Polymorphic Functions

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

Script Polymorphic Functions

2 31

2.1 years ago Eduard Turea
Demonstration of Streaming Table Function

What is a streaming table function? Well, first, a table function is a function executed with the TA...

Script STREAMING,TABLE FUNCTION

1 29

6.4 years ago Steven Feuerstein (Oracle)
PL/SQL String Tokenizer as a table function

This is a PL/SQL implementation to tokenize a string, based on a delimiter character, into a set of ...

Script tokens,varchar2,clob,parser

3 29

6.7 years ago Carsten Czarski (Oracle)
Split

This is a small pipelined table function that gets one string that includes a delimited list of valu...

Script split csv pipelined table function pl/sql

4 26

6.7 years ago Oren Nakdimon (DBoriented)
Polymorphic Table Functions (PTFs) with variables

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

Script Polymorphic Table Function PTF Pseudo-Operator

0 24

3.5 years ago Darryl Hurley
Outer_Apply_01

Example for using OUTER APPLY to outer join with a table function. See more details on OUTER APP...

Script apply, outer join,table function

1 23

6.7 years ago Lucas Jellema
18c polymorphic table function TAB2KEYVAL

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

Script 18c, PTF, UNPIVOT

5 20

4.3 years ago Andrej_SQL
Using nested tables and table functions to return data

Answering a StackOverflow question with some code! https://stackoverflow.com/questions/45743046/stor...

Script

0 15

4.9 years ago Steven Feuerstein (Oracle)
Ask TOM Answer: Pipelined-table functions with cursor return type

Example script for https://asktom.oracle.com/pls/apex/asktom.search?tag=ways-to-name-the-output-colu...

Script

1 14

3.2 years ago Chris Saxon (Oracle)
18c To_doc Polymorphic Table Function Example

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

Script 18c LNPLS

4 12

4.4 years ago Oracle
Materialized View Built on Table Function

A developer tried to do this and failed, so figured it was not possible. I figured I would prove him...

Script table function,materialized view

0 12

5.6 years ago Steven Feuerstein (Oracle)
Polymorphic Table Function Split Column

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

Script Polymorphic Table Function Split Column

1 12

3.5 years ago Patch72
18c Noop Polymorphic Table Function Example

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

Script 18c ARPLS

3 11

4.4 years ago Oracle
18c Skip_col Polymorphic Table Function Example

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

Script 18c LNPLS

0 11

4.4 years ago Oracle
Polymorphic Table Functions (PTFs) Interrogate what they are passed

Polymorphic Table Functions (PTFs) Interrogate what they are passed

Script Polymorphic Table Functions PTF

0 10

3.5 years ago Darryl Hurley
Polymorphic Table Function (PTF) Exception Demo

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

Script Polymorphic Table Functions PTF

1 8

3.5 years ago Darryl Hurley
18c Stack Polymorphic Table Function Example

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

Script 18c ARPLS

0 7

4.4 years ago Oracle
Polymorphic Table Function (PTF) Rick-Roll

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

Script Polymorphic Table Functions PTF

0 7

3.5 years ago Darryl Hurley
Remove columns from query output

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

Script SQL macros, polymorphic table functions, select except

1 7

5 months ago Chris Saxon (Oracle)
[ACollectionIsACollection][10g]table function parameter

Demo script displaying how to build and use a table function in Oracle 10g.

Script Collections Oracle10g Presentation Patrick Barel Patch72

0 7

1.7 years ago Patch72
12c: Skip the TABLE Operator w/Table Functions

As of 12.1, you can now call table functions in the FROM clause of a query without nesting it inside...

Script table function

0 6

5.4 years ago Steven Feuerstein (Oracle)
18c Row_num Polymorphic Table Function Example

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

Script 18c ARPLS

0 6

4.4 years ago Oracle
Pipelined table function split string into number of tokens per row

Pipelined table function with 3 parameters last two are default, case divisor is not equal to zero ...

Script

1 6

3.5 years ago João Belo
18c Replicate Polymorphic Table Function Example

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

Script 18c ARPLS

1 5

4.4 years ago Oracle
12.2 new feature - TABLE operator not needed for PTF

Small example to demonstrate that the TABLE operator is not needed anymore in a 12.2 environment for...

Script 12.2, feature demo

1 4

5 years ago Sven Weller
Polymorphic Table Function Split Column Variable Column Name Variable Separator

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

Script Polymorphic Table Function Split Arbitrary Column Arbitrary Separator

0 4

3.5 years ago Patch72
Polymorphic Table Functions (PTFs) Can Add Columns

PTFs can add column to the output.

Script Polymrphic Table Functions PTF

0 4

3.5 years ago Darryl Hurley
18c Rand_col Polymorphic Table Function Example

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

Script 18c ARPLS

0 3

4.4 years ago Oracle
18c Split Polymorphic Table Function Example

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

Script 18c ARPLS

0 3

4.4 years ago Oracle
Exploring table functions for Feuertip #22

In which we use a table about animal species to explore the flexibility of the from clause of a quer...

Script

1 3

10 months ago Steven Feuerstein
Polymorphic Table Function Split Column Variable Column Name

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

Script Polymorphic Table Function Split Arbitrary Column

0 3

3.5 years ago Patch72
table-function-demo

Demo of using a table function in a WHERE clause.

Script

0 3

5.5 years ago William Robertson
18c DBMS_TF Method Name Overrides

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

Script 18c ARPLS

0 2

4.4 years ago Oracle
[ACollectionIsACollection][9i]pipelined table function parameter

Demo script displaying how to build and use a pipelined table function in Oracle 9i.

Script Collections Oracle9i Presentation Patrick Barel Patch72

0 2

1.7 years ago Patch72
Get exceptions handling blocks from plsql programs using a table function

In Oracle 11.2 I created a table function that I use to know how the exceptions of a given plsql pro...

Script

2 1

3.4 years ago João Belo
[ACollectionIsACollection][11g]table function parameter

Demo script displaying how to build and use a table function in Oracle 10g.

Script Collections Oracle11g Presentation Patrick Barel Patch72

0 1

1.7 years ago Patch72
[ACollectionIsACollection][8i]table function parameter

Demo script displaying how to build and use a table function in Oracle 8i.

Script Collections Oracle8i Presentation Patrick Barel Patch72

0 1

1.7 years ago Patch72

row(s) 1 - 46 of 46