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 - 6
SQL Analytics - 48
SQL General - 470
Oracle Text - 10
Data Models - 11
PL/SQL General - 465
Partitioning - 34
Compression - 1
SQL Types - 5
Oracle 12c - 12
Performance and Tuning - 20
Geospatial - 2
NLS - 8
Data Mining/Machine Learning - 1
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
Introduction to SQL
This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create t...
Tutorial
create table, create, select, insert, update, delete, drop, drop table, recycle bin, purge
486
143,524
5.3 years ago
Mike Hichwa (Oracle)
PL/SQL Anonymous Blocks
Define blocks of procedural of code using PL/SQL.
Tutorial
84
22,897
5.3 years ago
Mike Hichwa (Oracle)
Subqueries: Databases for Developers
An introduction to using subqueries in Oracle Database
Tutorial
with clause, in, exists
120
16,667
2.7 years ago
Chris Saxon (Oracle)
Creating Tables: Databases for Developers
An introduction to creating tables and the types of these available in Oracle Database.
Tutorial
create table
75
14,538
3.4 years ago
Chris Saxon (Oracle)
Analytic Functions: Databases for Developers
An introduction to analytic functions.
Tutorial
analytics
159
11,592
2.7 years ago
Chris Saxon (Oracle)
Creating Analytic Views - Getting Started
In this tutorial you will learn how to create an analytic view using data in the AV sample schema. ...
Tutorial
analytic view
67
9,373
4.1 years ago
William Endress (Oracle)
SQL/JSON Features in Database 12.2
This Tutorial introduces the new JSON-related extensions to SQL and PL/SQL that have been added to O...
Tutorial
36
7,721
4.1 years ago
Roger Ford (Oracle)
Introduction to Sequences
Learn how to create database sequences and how they can be referenced from triggers and within PL/SQ...
Tutorial
create sequence
26
5,749
5.3 years ago
Mike Hichwa (Oracle)
Updating table data
This tutorial demonstrates different variations of the UPDATE statement. It includes examples of bas...
Tutorial
32
5,107
5.3 years ago
Oracle
Querying Null-valued Rows: Databases for Developers
An introduction to handling null, including three-valued logic and null related functions. Click "Ex...
Tutorial
nulls
31
4,709
2.8 years ago
Chris Saxon (Oracle)
Joining Tables: Databases for Developers
An introduction to the join types available in Oracle Database.
Tutorial
join, inner join, outer join, cross join
63
4,432
2.5 years ago
Chris Saxon (Oracle)
Converting Rows to Columns and Back Again: Databases for Developers
An introduction to how to use pivot & unpivot to convert rows to columns and back.
Tutorial
pivot, unpivot
45
4,332
2.7 years ago
Chris Saxon (Oracle)
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
41
3,716
2.6 years ago
Steven Feuerstein (Oracle)
Introduction to MATCH_RECOGNIZE
This is a simple example that introduces the main keywords used in MATCH_RECOGNIZE. During this tuto...
Tutorial
SQL, PATTERN MATCHING
28
3,452
4 years ago
Keith Laker (Oracle)
Hierarchical Queries: Databases for Developers
An introduction to using connect by and recursive with to traverse trees.
Tutorial
connect by, recursive with
44
3,403
2.7 years ago
Chris Saxon (Oracle)
Columns and Data Types: Databases for Developers
An introduction to the various data types available in Oracle Database.
Tutorial
create table, alter table
22
2,492
3.4 years ago
Chris Saxon (Oracle)
Sorting and Limiting Rows: Databases for Developers
An introduction to sorting data with order by and restricting rows to the top N.
Tutorial
order by, fetch first
32
2,480
2.7 years ago
Chris Saxon (Oracle)
Aggregating Rows: Databases for Developers
An introduction to how to summarise data using aggregate functions and group by.
Tutorial
group by, rollup, cube, count, sum
39
2,479
2.5 years ago
Chris Saxon (Oracle)
Partitioning in Oracle Database 12c Release 2 [Tutorial]
Tutorial introducing new and enhanced Partitioning functionality in Oracle Database 12c Release 2.
Tutorial
database, partitioning, performance, manageability, 12.2, Oracle Database 12c Release 2, Oracle Database 12.2
22
2,390
4.1 years ago
Hermann Baer (Oracle)
Union, Minus, and Intersect: Databases for Developers
An introduction to the set operators, union, minus, and intersect
Tutorial
union, minus, intersect
34
2,155
2.7 years ago
Chris Saxon (Oracle)
Merge: Databases for Developers
An introduction to how to use merge to do insert-or-update logic.
Tutorial
merge, upsert
22
1,622
2.6 years ago
Chris Saxon (Oracle)
JavaOne - Simplified and Fast Fraud Detection using SQL Pattern Matching
This session demonstrates how, using SQL pattern matching techniques, you can speed up searching for...
Tutorial
pattern, sql
12
1,602
3.3 years ago
Keith Laker (Oracle)
Querying and Filtering Rows: Databases for Developers
An introduction to returning data from tables with select and filtering the results using where. ...
Tutorial
select, where
30
1,554
3.4 years ago
Chris Saxon (Oracle)
Adding and Saving Rows: Databases for Developers
An introduction to adding rows to tables with insert. And saving or undoing these changes with commi...
Tutorial
insert, insert all, commit, rollback, savepoint
13
1,522
2.5 years ago
Chris Saxon (Oracle)
Querying Analytic Views - Getting Started
This tutorial provides an introduction to querying hierarchies and analytic views. This is a good s...
Tutorial
analytic views, hierarchy, hierarchies
17
1,480
4.1 years ago
William Endress (Oracle)
Table Design: Databases for Developers
An introduction to designing database tables.
Tutorial
13
1,465
2.5 years ago
Chris Saxon (Oracle)
Creating Time Series Calculations in Analytic Views
This tutorial provides examples for creating time series calculations such as prior periods, year ag...
Tutorial
analytic view, time series, LEAD, LAG, SHARE_OF
10
1,320
4.1 years ago
William Endress (Oracle)
Bulk Processing with PL/SQL
Learn how to make the most of the bulk processing features of PL/SQL: BULK COLLECT and FORALL. Be su...
Tutorial
bulk,forall,performance
36
1,205
1.7 years ago
Steven Feuerstein (Oracle)
Creating an Analytic View for the Sales History (SH) Sample Schema
This tutorial will create an analytic view and supporting objects using data in the Sales History (S...
Tutorial
analytic view, SH, sales history
7
1,077
4.1 years ago
William Endress (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
15
1,032
2.6 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
16
941
2.6 years ago
Steven Feuerstein (Oracle)
Update & Transactions: Databases for Developers
An introduction to how to change row values with update. Also an overview of how to manage transacti...
Tutorial
update, deadlock, select for update
16
939
2.5 years ago
Chris Saxon (Oracle)
HOL Analytic Functions (Kscope17)
Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of analytic functions i...
Tutorial
12
892
3.9 years ago
Kim Berg Hansen
Using the Analytic View Materialized Aggregate Cache
This tutorial shows how to use materialized views to accelerate queries that select from analytic vi...
Tutorial
analytic view, materialized view, aggregate, cache
8
860
4.1 years ago
William Endress (Oracle)
Removing Rows: Databases for Developers
An introduction to how to remove rows from a table using delete and truncate.
Tutorial
delete, truncate
11
840
2.4 years ago
Chris Saxon (Oracle)
New 12.2 Data Validation Features - CAST and VALIDATE_CONVERSION
The enhanced CAST function (along with TO_NUMBER, TO_BINARY_FLOAT, TO_BINARY_DOUBLE, TO_DATE, TO_TI...
Tutorial
SQL
6
820
4.1 years ago
Keith Laker (Oracle)
Read Phenomena & Isolation Levels: Databases for Developers
An introduction to the read consistency model in Oracle Database
Tutorial
read committed, serializable, set transaction, read only
6
652
2.6 years ago
Chris Saxon (Oracle)
Managing very long lists in 12.2 with LISTAGG
The tutorial will help explain the new 12.2 syntax for LISTAGG which provides developers with additi...
Tutorial
SQL, LISTAGG, 12.2
4
649
4.1 years ago
Keith Laker (Oracle)
MATCH_RECOGNIZE - importance of PARTITION BY and ORDER BY
The aim of this tutorial is to explain the importance of using PARTITION BY and ORDER BY to ensure t...
Tutorial
PATTERN MATCHING, MATCH_RECOGNIZE,
16
626
4.3 years ago
Keith Laker (Oracle)
Approximate Query Processing - Getting Started
Approximate Query Processing provides approximate result capabilities in SQL. The motivation behind ...
Tutorial
sql analytics,approximate query processing
4
615
4.1 years ago
Nigel Bayliss (Oracle)
Adding Multiple Language Support to Analytic Views
This tutorial provides examples of adding multiple language support to analytic views.
Tutorial
analytic views, nls
3
611
4 years ago
William Endress (Oracle)
MATCH_RECOGNIZE - Fraud demo for OracleCODE events
This is a simple demo showing how to use SQL pattern matching for fraud analysis. It is part of a pr...
Tutorial
PATTERN MATCHING, MATCH_RECOGNIZE,
9
607
3.9 years ago
Keith Laker (Oracle)
MATCH_RECOGNIZE - Log file sessionization analysis
How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis on web l...
Tutorial
pattern matching, sessionization, MATCH_RECOGNIZE
9
600
4.7 years ago
Keith Laker (Oracle)
HOL Row Pattern Matching (Kscope17)
Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of row pattern matching...
Tutorial
4
543
3.6 years ago
Kim Berg Hansen
Oracle XML DB : Storing and Processing XML Documents
Oracle XML DB is a set of Oracle Database technologies related to high-performance handling of XML d...
Tutorial
8
507
2.3 years ago
Oracle
MATCH_RECOGNIZE - Using Built-In Measures
In this tutorial we will review the two built-in measures that are part of MATCH_RECOGNIZE. These me...
Tutorial
MATCH_RECOGNZE, pattern matching
9
492
4.3 years ago
Keith Laker (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
10
413
2.6 years ago
Steven Feuerstein (Oracle)
Aggregating Data using Weighted Averages in Analytic Views
Weighted averages are often needed to correctly aggregate average in aggregate levels of a hierarchy...
Tutorial
analytic view, aggregation, weighted average
8
359
2.4 years ago
William Endress (Oracle)
Sessionization with MATCH_RECOGNIZE and JSON
How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis based on...
Tutorial
pattern matching, sessionization, MATCH_RECOGNIZE, JSON
6
285
3.8 years ago
Keith Laker (Oracle)
MATCH_RECOGNIZE - Empty Matches and Unmatched Rows
The aim of this tutorial is to explain the difference between the various row output options within ...
Tutorial
PATTERN MATCHING, MATCH_RECOGNIZE,
6
248
4.3 years ago
Keith Laker (Oracle)
Real World Problem Solving with SQL
Examples of how to use SQL to solve real problems, as discussed in the database@home event. https...
Tutorial
match_recognize, sum, analytic functions
12
238
9 months ago
Chris Saxon (Oracle)
SODA for PL/SQL
SODA for PL/SQL is a PL/SQL API that implements Simple Oracle Document Access (SODA). You can use it...
Tutorial
SODA JSON NOSQL SQL
1
218
1.4 years ago
Srikrishnan S Suresh (Oracle)
Creating SHARE_OF (Hierarchical Ratio) Calculations in Analytic Views
SHARE_OF expressions calculate the ratio of a hierarchy value to the value of a parent or an ancesto...
Tutorial
analytic view, SHARE_OF, ratio, QUALIFY
3
196
4.1 years ago
William Endress (Oracle)
Managing strings with MATCH_RECOGNIZE
This tutorial is linked to one of my blog posts"Managing overflows in LISTAGG" - https://oracle-big-...
Tutorial
4
194
3.8 years ago
Keith Laker (Oracle)
MATCH_RECOGNIZE - SKIP TO where exactly?
We use the AFTER MATCH SKIP clause to determine the precise point to resume row pattern matching aft...
Tutorial
PATTERN MATCHING, MATCH_RECOGNIZE,
5
182
4.2 years ago
Keith Laker (Oracle)
Introduction to Location-Based Analysis Using Spatial Features of Oracle Database
The tutorial introduces location-based analysis using Oracle Spatial and Graph. Spatial data are loa...
Tutorial
spatial, gis
6
166
1.5 years ago
David Lapp (Oracle)
Using FILTER FACT to Extend Analytic View Aggregation in SELECT
When SELECTing data from an analytic view the FILTER FACT keywords can be used to filter data prior ...
Tutorial
analytic view, filter fact, aggregation
3
163
2.5 years ago
William Endress (Oracle)
Oracle Text Quickstart
Getting started with Oracle Text
Tutorial
Oracle Text, CTX, CONTAINS, CONTEXT
5
151
1.6 years ago
Roger Ford (Oracle)
MATCH_RECOGNIZE - Greedy vs. Reluctant Quantifiers
In this tutorial we will review the concepts of greedy and reluctant quantifiers. Pattern quantifier...
Tutorial
PATTERN MATCHING, MATCH_RECOGNIZE,
5
141
4.3 years ago
Keith Laker (Oracle)
MATCH_RECOGNIZE - What to include in the MEASURES clause
This tutorial will help you understand why you might get errors such as ORA-904 "%s: invalid identif...
Tutorial
5
134
3.9 years ago
Keith Laker (Oracle)
row(s) 1 - 60 of 72
Next