Skip to Main Content
Oracle
Live SQL
Help
Sign In
Dark Mode
Home
Home
SQL Worksheet
SQL Worksheet
My Session
My Session
Previous Sessions
Previously Viewed
Utilization
NLS
Schema
Schema
Quick SQL
Quick SQL
My Models
My Scripts
My Scripts
My Tutorials
My Tutorials
Code Library
Code Library
Code Library
Breadcrumb
Search
Area
All
Oracle 19c - 1
SQL General - 8
PL/SQL General - 36
Category
All
Types
All
Tutorials
Scripts
Sort By
Date Added
Executions
Name
Likes
Sort Order
Ascending
Descending
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
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
64
5,548
4.8 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
22
1,416
4.8 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
23
1,330
4.8 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...
16
532
4.8 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
11
67
5.1 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
1
48
6.9 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
7
42
6.4 years ago
Darryl Hurley
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
2
36
5.1 years ago
Sarah Hirschfeld (Oracle)
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
3
32
7.4 years ago
Carsten Czarski (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
2
32
2.9 years ago
Eduard Turea
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
4
30
7.5 years ago
Oren Nakdimon (DBoriented)
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
1
29
7.2 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
1
24
4.3 years ago
Darryl Hurley
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
1
24
7.5 years ago
Lucas Jellema
Script
18c polymorphic table function TAB2KEYVAL
An example of using a polymorphic table function (PTF) to transpose columns to rows
18c, PTF, UNPIVOT
5
22
5.1 years ago
Andrej_SQL
Script
Using nested tables and table functions to return data
Answering a StackOverflow question with some code! https://stackoverflow.com/questions/45743046/stor...
0
15
5.6 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...
1
15
3.9 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
4
14
5.1 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
1
12
4.3 years ago
Patch72
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
0
12
6.4 years ago
Steven Feuerstein
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
0
12
5.1 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
3
12
5.1 years ago
Sarah Hirschfeld (Oracle)
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
0
11
5.1 years ago
Sarah Hirschfeld (Oracle)
Script
Polymorphic Table Functions (PTFs) Interrogate what they are passed
Polymorphic Table Functions (PTFs) Interrogate what they are passed
Polymorphic Table Functions PTF
0
10
4.3 years ago
Darryl Hurley
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
1
8
1.2 years ago
Chris Saxon (Oracle)
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
1
8
4.3 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
0
7
2.4 years ago
Patch72
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
0
7
4.3 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
0
7
5.1 years ago
Sarah Hirschfeld (Oracle)
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 ...
1
6
4.2 years ago
João Belo
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
6
6.2 years ago
Steven Feuerstein
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
1
5
5.1 years ago
Sarah Hirschfeld (Oracle)
Script
Polymorphic Table Functions (PTFs) Can Add Columns
PTFs can add column to the output.
Polymrphic Table Functions PTF
0
4
4.3 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
0
4
4.3 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
1
4
5.7 years ago
Sven Weller
Script
table-function-demo
Demo of using a table function in a WHERE clause.
0
3
6.2 years ago
William Robertson
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
0
3
4.3 years ago
Patch72
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...
1
3
1.6 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
0
3
5.1 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
0
3
5.1 years ago
Sarah Hirschfeld (Oracle)
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
0
2
2.4 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...
2
2
4.1 years ago
João Belo
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
0
2
5.1 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
1
2.4 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
2.4 years ago
Patch72
row(s) 1 - 45 of 45