Code Library - Oracle Live SQL

Tutorial

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

table function

87 7,054

7.1 years ago Steven Feuerstein

Tutorial

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

pipelined table function

29 1,716

7.1 years ago Steven Feuerstein

Tutorial

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

table function

33 1,614

7.1 years ago Steven Feuerstein

Tutorial

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

21 628

7.1 years ago Steven Feuerstein

Script

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

18c, polymorphic table functions

12 71

7.4 years ago Chris Saxon (Oracle)

Script

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

table function

2 52

9.2 years ago Steven Feuerstein

Script

Table Functions and Ref Cursors

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

Table Functions PLSQL REF Cursor PARALLEL_ENABLE

9 46

8.7 years ago Darryl Hurley

Script

Split

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

split csv pipelined table function pl/sql

5 38

9.7 years ago Oren Nakdimon (DBoriented)

Script

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

18c ARPLS

3 38

7.3 years ago Sarah Hirschfeld (Oracle)

Script

Dynamic formula evaluation using Polymorphic Functions

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

Polymorphic Functions

4 35

5.1 years ago Eduard Turea

Script

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

tokens,varchar2,clob,parser

4 32

9.7 years ago Carsten Czarski (Oracle)

Script

Outer_Apply_01

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

apply, outer join,table function

2 32

9.7 years ago Lucas Jellema

Script

Demonstration of Streaming Table Function

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

STREAMING,TABLE FUNCTION

2 29

9.5 years ago Steven Feuerstein

Script

Polymorphic Table Functions (PTFs) with variables

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

Polymorphic Table Function PTF Pseudo-Operator

2 26

6.5 years ago Darryl Hurley

Script

18c polymorphic table function TAB2KEYVAL

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

18c, PTF, UNPIVOT

6 24

7.4 years ago Andrej_SQL

Script

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

18c LNPLS

1 16

7.4 years ago Sarah Hirschfeld (Oracle)

Script

Using nested tables and table functions to return data

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

1 15

7.9 years ago Steven Feuerstein

Script

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

2 15

6.2 years ago Chris Saxon (Oracle)

Script

18c To_doc Polymorphic Table Function Example

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

18c LNPLS

5 15

7.4 years ago Sarah Hirschfeld (Oracle)

Script

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

table function,materialized view

1 13

8.7 years ago Steven Feuerstein

Script

18c Stack Polymorphic Table Function Example

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

18c ARPLS

1 13

7.4 years ago Sarah Hirschfeld (Oracle)

Script

18c Noop Polymorphic Table Function Example

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

18c ARPLS

4 13

7.4 years ago Sarah Hirschfeld (Oracle)

Script

Polymorphic Table Function Split Column

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

Polymorphic Table Function Split Column

2 12

6.5 years ago Patch72

Script

Remove columns from query output

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

SQL macros, polymorphic table functions, select except

2 11

3.5 years ago Chris Saxon (Oracle)

Script

Polymorphic Table Functions (PTFs) Interrogate what they are passed

Polymorphic Table Functions PTF

1 10

6.5 years ago Darryl Hurley

Script

[ACollectionIsACollection][10g]table function parameter

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

Collections Oracle10g Presentation Patrick Barel Patch72

1 9

4.7 years ago Patch72

Script

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

Polymorphic Table Functions PTF

2 8

6.5 years ago Darryl Hurley

Script

Polymorphic Table Function (PTF) Rick-Roll

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

Polymorphic Table Functions PTF

1 7

6.5 years ago Darryl Hurley

Script

18c Row_num Polymorphic Table Function Example

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

18c ARPLS

1 7

7.4 years ago Sarah Hirschfeld (Oracle)

Script

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

table function

0 7

8.4 years ago Steven Feuerstein

Script

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

2 6

6.5 years ago João Belo

Script

18c Replicate Polymorphic Table Function Example

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

18c ARPLS

2 6

7.4 years ago Sarah Hirschfeld (Oracle)

Script

table-function-demo

Demo of using a table function in a WHERE clause.

1 4

8.5 years ago William Robertson

Script

[ACollectionIsACollection][9i]pipelined table function parameter

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

Collections Oracle9i Presentation Patrick Barel Patch72

1 4

4.7 years ago Patch72

Script

Polymorphic Table Functions (PTFs) Can Add Columns

PTFs can add column to the output.

Polymrphic Table Functions PTF

1 4

6.5 years ago Darryl Hurley

Script

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

Polymorphic Table Function Split Arbitrary Column Arbitrary Separator

1 4

6.5 years ago Patch72

Script

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

12.2, feature demo

2 4

8 years ago Sven Weller

Script

Polymorphic Table Function Split Column Variable Column Name

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

Polymorphic Table Function Split Arbitrary Column

1 3

6.5 years ago Patch72

Script

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

3 3

6.4 years ago João Belo

Script

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

2 3

3.9 years ago Steven Feuerstein

Script

18c Split Polymorphic Table Function Example

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

18c ARPLS

1 3

7.4 years ago Sarah Hirschfeld (Oracle)

Script

18c Rand_col Polymorphic Table Function Example

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

18c ARPLS

1 3

7.4 years ago Sarah Hirschfeld (Oracle)

Script

18c DBMS_TF Method Name Overrides

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

18c ARPLS

1 3

7.4 years ago Sarah Hirschfeld (Oracle)

Script

[ACollectionIsACollection][8i]table function parameter

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

Collections Oracle8i Presentation Patrick Barel Patch72

0 2

4.7 years ago Patch72

Script

[ACollectionIsACollection][11g]table function parameter

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

Collections Oracle11g Presentation Patrick Barel Patch72

0 1

4.7 years ago Patch72