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
SQL General - 12
Oracle Text - 1
PL/SQL General - 19
Partitioning - 1
Performance and Tuning - 2
NLS - 1
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
Script
JSON Generation Enhancements in Oracle Database 18c
This script showcases the enhancements that have been to the JSON Generation operators in Oracle 18...
18c JSON
5
102
7.4 years ago
Oracle
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
#18c - optimizer_ignore_hints.sql
optimizer_ignore_hints is now documented (was an underscore parameter). In this example, an hint pre...
18c
3
47
7.4 years ago
Franck Pachot
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.4 years ago
Sarah Hirschfeld (Oracle)
Script
18c Private Temporary Tables, memory or disk?
Quick demo to show whether new private temporary tables use memory or disk.
18c, private gtt, gtt memory
0
36
7.4 years ago
Andrew Sayer
Script
18c private temporary tables
18c private temporary tables
18c, private, temporary, tables
3
35
7.4 years ago
Connor Mcdonald (Oracle)
Script
SODA API for PL/SQL
With the release of 18c, Simple Oracle Document Access (SODA) APIs have been extended to PL/SQL. Thi...
18c,soda,document
2
34
6.5 years ago
Steven Feuerstein
Script
18c Assigning Values to Associative Array Type Variables Using Qualified Expressions
This example uses a function to display the values of a table of BOOLEAN.
18c
1
32
7.3 years ago
Sarah Hirschfeld (Oracle)
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
Faceted Navigation Support for Oracle Text
Faceted navigation enables you to get summary details with Oracle Text search results.
18c, faceted navigation, Text
0
21
7.4 years ago
Chris Saxon (Oracle)
Script
18c approx_count function
Data analysis applications heavily use aggregate functions. Approximate query processing (available ...
18c, approx_count
2
19
7.4 years ago
Connor Mcdonald (Oracle)
Script
18c Assigning Values to RECORD Type Variables Using Qualified Expressions
This example shows the declaration, initialization, and definition of RECORD type variables.
18c
0
18
7.3 years ago
Sarah Hirschfeld (Oracle)
Script
Problematic dynamic Merge statement with plsql and binds
Script shows a problem with executing dynamic merge statements (my dba is filing a bug report). If ...
plsql merge dynamic with subquery factoring bind
0
16
9.5 years ago
Erik van Roon
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
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
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
Scalable Sequences
Examples of how scalable sequences in 18c work
18c, sequence
0
12
7.4 years ago
Chris Saxon (Oracle)
Script
Qualified Expressions for Records (aka, record constructors)
Aggregates and their necessary adjunct, qualified expressions, improve program clarity and programme...
18c,record,initialize
1
12
7.4 years ago
Steven Feuerstein
Script
Oracle 18c- Private Temporary Tables
Private temp tables
18c
1
11
7.4 years ago
Mandeep Kaur Sandhu
Script
Oracle 18c - JSON Enhancments
I was very excited when I come to know that Oracle 12c is going to support JSON. But the features su...
JSON
3
11
7.4 years ago
WiseCoder
Script
Qualified Expressions for Associative Arrays (aka, collection constructors)
Aggregates and their necessary adjunct, qualified expressions, improve program clarity and programme...
18c,collection,array,initialize,constructor
4
10
7.4 years ago
Steven Feuerstein
Script
Enhanced JSON Function Data Type Support
The JSON functions in 18c now support the following SQL data types: * BINARY_DOUBLE * BINARY_FLOAT *...
18c, JSON
2
10
7.4 years ago
Chris Saxon (Oracle)
Script
18c character encoding validation
New routines in UTL_I18N allow for validation of characters within a particular characterset
18c, validation
0
7
7.4 years ago
Connor Mcdonald (Oracle)
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
JSON_table Enhancements
Examples showing the simplified format for JSON_table expressions
18c, JSON, JSON_table
2
6
7.4 years ago
Chris Saxon (Oracle)
Script
18c merge online
Merge partitions on line without service interruption
18c, merge, online
0
6
7.4 years ago
Connor Mcdonald (Oracle)
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
JSON_equal Condition
Examples of how the new condition in 18c, json_equal, works to compare JSON documents.
18c, JSON, JSON_equal
1
5
7.4 years ago
Chris Saxon (Oracle)
Script
Database 18c TREAT(... AS JSON)
This script showcases the new (TREAT ... as JSON) operator introduced as part of Oracle Database 18c...
18c
1
5
7.4 years ago
Oracle
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
mimic dbms_xplan routines in livesql
Mimic dbms_xplan routines in livesql using queries against the underlying V$ views
18c, dbms_xplan, execution plan
0
1
7.4 years ago
Connor Mcdonald (Oracle)
Script
[ACollectionIsACollection][18c]qualified expressions AA and RECORD
Demo script displaying how much easier and readable the use of Qualified Expressions is compared to ...
Collections Oracle18c Presentation Patrick Barel Patch72
0
1
4.7 years ago
Patch72
Script
[ACollectionIsACollection][18c]qualified expressions AA
Demo script displaying how much easier and readable the use of Qualified Expressions is compared to ...
Collections Oracle18c Presentation Patrick Barel Patch72
0
1
4.7 years ago
Patch72
row(s) 1 - 36 of 36