Skip to Main Content
Oracle
Live SQL
Help
Sign In
Home
SQL Worksheet
My Session
Previous Sessions
Utilization
NLS
Schema
Quick SQL
My Models
My Scripts
My Tutorials
Code Library
Code Library
Breadcrumb
Search
Area
All
Oracle 19c - 1
SQL General - 9
PL/SQL General - 36
Category
All
Types
All
Tutorials
Scripts
Sort By
Date Added
Executions
Name
Likes
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
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