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 - 7
SQL Analytics - 54
SQL General - 504
Oracle Text - 10
Data Models - 11
PL/SQL General - 484
Partitioning - 35
Compression - 1
SQL Types - 6
Oracle 12c - 12
Performance and Tuning - 21
Geospatial - 2
NLS - 8
Data Mining/Machine Learning - 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
Tutorial
Introduction to SQL
This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create t...
create table, create, select, insert, update, delete, drop, drop table, recycle bin, purge
1,278
307,213
9 years ago
Mike Hichwa (Oracle)
Tutorial
PL/SQL Anonymous Blocks
Define blocks of procedural code using PL/SQL.
235
44,894
9 years ago
Mike Hichwa (Oracle)
Tutorial
Creating Tables: Databases for Developers
An introduction to creating tables and the types of these available in Oracle Database.
create table
205
39,165
7.1 years ago
Chris Saxon (Oracle)
Tutorial
Analytic Functions: Databases for Developers
An introduction to analytic functions.
analytics
499
37,279
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Subqueries: Databases for Developers
An introduction to using subqueries in Oracle Database
with clause, in, exists
257
27,817
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Joining Tables: Databases for Developers
An introduction to the join types available in Oracle Database.
join, inner join, outer join, cross join
195
14,203
6.2 years ago
Chris Saxon (Oracle)
Tutorial
Creating Analytic Views - Deep Dive
In this tutorial you will learn how to create an analytic view using data in the AV sample schema. ...
analytic view
131
14,035
7.8 years ago
William Endress (Oracle)
Tutorial
SQL/JSON Features in Oracle Database
Many new features have been added to support JSON development in recent releases. This Tutorial i...
JSON appdev
67
11,143
7.8 years ago
Roger Ford (Oracle)
Tutorial
Introduction to Sequences
Learn how to create database sequences and how they can be referenced from triggers and within PL/SQ...
create sequence
70
9,639
9 years ago
Mike Hichwa (Oracle)
Tutorial
Updating table data
This tutorial demonstrates different variations of the UPDATE statement. It includes examples of bas...
69
9,462
9 years ago
Oracle
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
84
6,731
6.3 years ago
Steven Feuerstein
Tutorial
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.
pivot, unpivot
87
6,707
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Querying Null-valued Rows: Databases for Developers
An introduction to handling null, including three-valued logic and null related functions. Click "Ex...
nulls
68
6,402
6.5 years ago
Chris Saxon (Oracle)
Tutorial
Aggregating Rows: Databases for Developers
An introduction to how to summarise data using aggregate functions and group by.
group by, rollup, cube, count, sum
94
5,235
6.2 years ago
Chris Saxon (Oracle)
Tutorial
Hierarchical Queries: Databases for Developers
An introduction to using connect by and recursive with to traverse trees.
connect by, recursive with
90
5,231
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Introduction to MATCH_RECOGNIZE
This is a simple example that introduces the main keywords used in MATCH_RECOGNIZE. During this tuto...
SQL, PATTERN MATCHING
53
4,533
7.7 years ago
Keith Laker (Oracle)
Tutorial
Columns and Data Types: Databases for Developers
An introduction to the various data types available in Oracle Database.
create table, alter table
66
4,429
7.1 years ago
Chris Saxon (Oracle)
Tutorial
Sorting and Limiting Rows: Databases for Developers
An introduction to sorting data with order by and restricting rows to the top N.
order by, fetch first
64
4,160
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Union, Minus, and Intersect: Databases for Developers
An introduction to the set operators, union, minus, and intersect
union, minus, intersect
86
4,036
6.4 years ago
Chris Saxon (Oracle)
Tutorial
Enhanced Partitioning techniques in Oracle Database [Tutorial]
Tutorial introducing somewhat more enhanced Partitioning functionality in Oracle Database.
database, partitioning, performance, manageability, Oracle Database
41
3,437
7.8 years ago
Hermann Baer (Oracle)
Tutorial
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...
bulk,forall,performance
77
3,252
5.4 years ago
Steven Feuerstein
Tutorial
Querying and Filtering Rows: Databases for Developers
An introduction to returning data from tables with select and filtering the results using where. ...
select, where
64
3,188
7.1 years ago
Chris Saxon (Oracle)
Tutorial
Adding and Saving Rows: Databases for Developers
An introduction to adding rows to tables with insert. And saving or undoing these changes with commi...
insert, insert all, commit, rollback, savepoint
31
2,909
6.2 years ago
Chris Saxon (Oracle)
Tutorial
Merge: Databases for Developers
An introduction to how to use merge to do insert-or-update logic.
merge, upsert
46
2,751
6.3 years ago
Chris Saxon (Oracle)
Tutorial
Table Design: Databases for Developers
An introduction to designing database tables.
30
2,378
6.2 years ago
Chris Saxon (Oracle)
Tutorial
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...
pattern, sql
22
2,150
7 years ago
Keith Laker (Oracle)
Tutorial
Querying Analytic Views - Deep Dive
This tutorial provides an introduction to querying hierarchies and analytic views. This is a good s...
analytic views, hierarchy, hierarchies
36
2,082
7.8 years ago
William Endress (Oracle)
Tutorial
Creating Time Series Calculations in Analytic Views
This tutorial provides examples for creating time series calculations such as prior periods, year ag...
analytic view, time series, LEAD, LAG, SHARE_OF
24
2,050
7.8 years ago
William Endress (Oracle)
Tutorial
Update & Transactions: Databases for Developers
An introduction to how to change row values with update. Also an overview of how to manage transacti...
update, deadlock, select for update
28
1,769
6.2 years ago
Chris Saxon (Oracle)
Tutorial
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...
analytic view, SH, sales history
11
1,675
7.8 years ago
William Endress (Oracle)
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
28
1,673
6.3 years ago
Steven Feuerstein
Tutorial
Removing Rows: Databases for Developers
An introduction to how to remove rows from a table using delete and truncate.
delete, truncate
24
1,584
6.1 years ago
Chris Saxon (Oracle)
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
31
1,575
6.3 years ago
Steven Feuerstein
Tutorial
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...
SQL
10
1,365
7.8 years ago
Keith Laker (Oracle)
Tutorial
Real World Problem Solving with SQL
Examples of how to use SQL to solve real problems, as discussed in the database@home event. https...
match_recognize, sum, analytic functions
39
1,289
4.4 years ago
Chris Saxon (Oracle)
Tutorial
HOL Analytic Functions
Hands-On-Lab for ODTUG Kscope. The modules give examples of analytic functions in increasing comp...
19
1,254
7.6 years ago
Kim Berg Hansen
Tutorial
Using the Analytic View Materialized Aggregate Cache
This tutorial shows how to use materialized views to accelerate queries that select from analytic vi...
analytic view, materialized view, aggregate, cache
14
1,157
7.8 years ago
William Endress (Oracle)
Tutorial
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...
PATTERN MATCHING, MATCH_RECOGNIZE,
21
1,051
8 years ago
Keith Laker (Oracle)
Tutorial
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...
11
1,013
6 years ago
Oracle
Tutorial
Approximate Query Processing - Getting Started
Approximate Query Processing provides approximate result capabilities in SQL. The motivation behind ...
sql analytics,approximate query processing
8
941
7.8 years ago
Nigel Bayliss (Oracle)
Tutorial
Adding Multiple Language Support to Analytic Views
This tutorial provides examples of adding multiple language support to analytic views.
analytic views, nls
6
940
7.7 years ago
William Endress (Oracle)
Tutorial
Read Phenomena & Isolation Levels: Databases for Developers
An introduction to the read consistency model in Oracle Database
read committed, serializable, set transaction, read only
10
939
6.3 years ago
Chris Saxon (Oracle)
Tutorial
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...
SQL, LISTAGG, 12.2
10
939
7.8 years ago
Keith Laker (Oracle)
Tutorial
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...
PATTERN MATCHING, MATCH_RECOGNIZE,
13
822
7.6 years ago
Keith Laker (Oracle)
Tutorial
MATCH_RECOGNIZE - Log file sessionization analysis
How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis on web l...
pattern matching, sessionization, MATCH_RECOGNIZE
12
794
8.4 years ago
Keith Laker (Oracle)
Tutorial
How Joins Work: Databases for Developers: Performance #7
An overview of the different join methods in Oracle Database: nested loops, hash joins, and merge jo...
performance, join methods
21
691
4.7 years ago
Chris Saxon (Oracle)
Tutorial
HOL Row Pattern Matching
Hands-On-Lab for ODTUG Kscope. The modules give examples of row pattern matching (MATCH_RECOGNIZE...
7
630
7.3 years ago
Kim Berg Hansen
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...
20
619
6.3 years ago
Steven Feuerstein
Tutorial
How to Get and Read Execution Plans: Databases for Developers: Performance #1
Execution plans are one of the key tools to help understand SQL performance. This tutorial shows you...
performance, dbms_xplan, execution plan
25
586
4.7 years ago
Chris Saxon (Oracle)
Tutorial
Aggregating Data using Weighted Averages in Analytic Views
Weighted averages are often needed to correctly aggregate average in aggregate levels of a hierarchy...
analytic view, aggregation, weighted average
13
538
6.1 years ago
William Endress (Oracle)
Tutorial
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...
MATCH_RECOGNZE, pattern matching
11
532
8 years ago
Keith Laker (Oracle)
Tutorial
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...
spatial, gis
8
428
5.2 years ago
David Lapp (Oracle)
Tutorial
Tuning Inserts, Updates, and Deletes: Databases for Developers: Performance #8
While most tuning efforts relate to making queries faster, often you need to make writes faster too....
performance, insert, update, delete
13
376
4.7 years ago
Chris Saxon (Oracle)
Tutorial
How to Create Materialized Views: Databases for Developers: Performance #6
An introduction to materialized views. These can make queries aggregating millions or billions of ro...
materialized views
18
360
4.7 years ago
Chris Saxon (Oracle)
Tutorial
How to Create Indexes: Databases for Developers: Performance #4
An introduction to creating indexes in Oracle Database. This teaches you how to create an index and ...
index, performance
11
337
4.7 years ago
Chris Saxon (Oracle)
Tutorial
Sessionization with MATCH_RECOGNIZE and JSON
How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis based on...
pattern matching, sessionization, MATCH_RECOGNIZE, JSON
6
329
7.5 years ago
Keith Laker (Oracle)
Tutorial
Oracle Text Quickstart
Getting started with Oracle Text
Oracle Text, CTX, CONTAINS, CONTEXT
8
324
5.3 years ago
Roger Ford (Oracle)
Tutorial
How to Find Slow SQL: Databases for Developers: Performance #9
An overview of the profiling tools SQL trace and the PL/SQL hierarchical profiler
performance
12
323
4.7 years ago
Chris Saxon (Oracle)
Tutorial
SQL Macros - Creating parameterised views
This tutorial explains how to create a parameterized view using SQL Macros. The examples use the bui...
19c, macros, sql
16
303
4 years ago
Keith Laker (Oracle)
Tutorial
MATCH_RECOGNIZE - Empty Matches and Unmatched Rows
The aim of this tutorial is to explain the difference between the various row output options within ...
PATTERN MATCHING, MATCH_RECOGNIZE,
7
295
8 years ago
Keith Laker (Oracle)
row(s) 1 - 60 of 78
Next