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 - 7
SQL Analytics - 49
SQL General - 492
Oracle Text - 10
Data Models - 11
PL/SQL General - 482
Partitioning - 35
Compression - 1
SQL Types - 6
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
915
225,422
7.1 years ago
Mike Hichwa (Oracle)
EMP and DEPT
Example EMP and DEPT tables. Classic Oracle tables with 4 departments and 14 employees. Includes a...
Script
EMP, DEPT, JOIN, referential integrity
984
186,642
7.1 years ago
Mike Hichwa (Oracle)
HR Objects and Data For Live SQL
This script will create the HR Sample Schema objects and data in your local schema. If you want jus...
Script
SQL, HR Schema, Employees Table, Departments Table
648
114,924
4.4 years ago
Oracle
PL/SQL Anonymous Blocks
Define blocks of procedural code using PL/SQL.
Tutorial
160
33,996
7.1 years ago
Mike Hichwa (Oracle)
Creating Tables: Databases for Developers
An introduction to creating tables and the types of these available in Oracle Database.
Tutorial
create table
149
27,043
5.2 years ago
Chris Saxon (Oracle)
Analytic Functions: Databases for Developers
An introduction to analytic functions.
Tutorial
analytics
357
25,893
4.6 years ago
Chris Saxon (Oracle)
Subqueries: Databases for Developers
An introduction to using subqueries in Oracle Database
Tutorial
with clause, in, exists
191
23,264
4.6 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
106
11,912
5.9 years ago
William Endress (Oracle)
SQL/JSON Features in Database 12.2 and 19c
Many new features have been added to support JSON development in 12.2 and 19c. This Tutorial intr...
Tutorial
JSON appdev
50
9,464
5.9 years ago
Roger Ford (Oracle)
Joining Tables: Databases for Developers
An introduction to the join types available in Oracle Database.
Tutorial
join, inner join, outer join, cross join
125
9,364
4.3 years ago
Chris Saxon (Oracle)
Baseball Teams and Players
Creates two tables: PLAYERS and TEAMS Teams are World Series teams from 2014: The Kansas City Roy...
Script
99
8,216
7.1 years ago
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
47
7,763
7.1 years ago
Mike Hichwa (Oracle)
Updating table data
This tutorial demonstrates different variations of the UPDATE statement. It includes examples of bas...
Tutorial
51
7,622
7.1 years ago
Oracle
Hello World
Simple example showing how to write text to the console.
Script
DBMS_OUTPUT, pl/sql
90
6,810
7.1 years ago
Mike Hichwa (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
48
5,630
4.6 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
67
5,597
4.6 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
60
5,190
4.5 years ago
Steven Feuerstein
Hierarchical Queries: Databases for Developers
An introduction to using connect by and recursive with to traverse trees.
Tutorial
connect by, recursive with
71
4,458
4.5 years ago
Chris Saxon (Oracle)
SQL Joins
SQL Join query examples, used to select rows from multiple tables using a join key.
Script
SELF JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN
162
4,175
7.1 years ago
Mike Hichwa (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
45
4,066
5.8 years ago
Keith Laker (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
72
3,907
4.3 years ago
Chris Saxon (Oracle)
Car Database
Database to perform Advanced DML, PL/SQL, Triggers, Procedure and Functions
Script
63
3,858
5.1 years ago
Karan
Columns and Data Types: Databases for Developers
An introduction to the various data types available in Oracle Database.
Tutorial
create table, alter table
46
3,603
5.2 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
48
3,298
4.6 years ago
Chris Saxon (Oracle)
Union, Minus, and Intersect: Databases for Developers
An introduction to the set operators, union, minus, and intersect
Tutorial
union, minus, intersect
62
3,189
4.5 years ago
Chris Saxon (Oracle)
Simple Explain Plan
This script explains the plan for a query of the sh.sales and sh.products tables.
Script
execution plan
56
3,126
7.1 years ago
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
36
2,994
5.9 years ago
Hermann Baer (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
45
2,584
5.2 years ago
Chris Saxon (Oracle)
Orders and Items Schema
Sample products, orders, and items schema with sample data.
Script
Order Items, schema, data model, orders, items, customers, plsql
54
2,573
7.1 years ago
Mike Hichwa (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
26
2,283
4.3 years ago
Chris Saxon (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
56
2,281
3.5 years ago
Steven Feuerstein
Merge: Databases for Developers
An introduction to how to use merge to do insert-or-update logic.
Tutorial
merge, upsert
37
2,275
4.4 years ago
Chris Saxon (Oracle)
Table Design: Databases for Developers
An introduction to designing database tables.
Tutorial
25
2,038
4.3 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
17
1,929
5.2 years ago
Keith Laker (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
27
1,844
5.9 years ago
William Endress (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
20
1,772
5.9 years ago
William Endress (Oracle)
Analytics - Ranking rows across an entire table
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
ranking, kiss
30
1,754
7 years ago
Connor Mcdonald (Oracle)
World Population Queries
Aggregation and various queries on shared world population schema data.
Script
AGGREGATION, TOP-N, TOP-10, LEAD, RANK
63
1,609
7.1 years ago
Mike Hichwa (Oracle)
Pivot and unpivot examples using Olympic data
Examples of pivoting and unpivoting data. Uses a subset of the results from the Rio Olympics as a da...
Script
pivot unpivot
74
1,565
6.2 years ago
Chris Saxon (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
22
1,409
4.3 years ago
Chris Saxon (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
10
1,401
5.9 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
21
1,356
4.5 years ago
Steven Feuerstein
Removing Rows: Databases for Developers
An introduction to how to remove rows from a table using delete and truncate.
Tutorial
delete, truncate
21
1,278
4.2 years ago
Chris Saxon (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
22
1,264
4.5 years ago
Steven Feuerstein
Contacts Schema
Simple schema to use to practice SQL
Script
30
1,176
7.1 years ago
Mike Hichwa (Oracle)
HOL Analytic Functions
Hands-On-Lab for ODTUG Kscope. The modules give examples of analytic functions in increasing comp...
Tutorial
17
1,132
5.8 years ago
Kim Berg Hansen
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
8
1,107
5.9 years ago
Keith Laker (Oracle)
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
11
1,024
5.9 years ago
William Endress (Oracle)
Different Types of Cursors in PL/SQL
An exploration into the different ways you can define and use cursors (pointers to SQL result sets) ...
Script
cursor
80
992
6.6 years ago
Steven Feuerstein
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,
20
872
6.1 years ago
Keith Laker (Oracle)
Analytics - Ranking part 3
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
10
852
6.9 years ago
Connor Mcdonald (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
31
828
2.6 years ago
Chris Saxon (Oracle)
Top N Query
Database 11g top N query syntax, Show top N rows of a query result
Script
TOP-N, top
30
817
7.1 years ago
Mike Hichwa (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
9
815
5.9 years ago
Keith Laker (Oracle)
19C LISTAGG DISTINCT
The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword....
Script
19c LISTAGG
44
807
3.9 years ago
Oracle
How to Find Gaps in Dates with SQL Pattern Matching
This shows you how to find gaps in rows containing start/end dates using match_recognize. You can ma...
Script
match_recognize, SQL Macro
25
801
2.2 years ago
Chris Saxon (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
9
797
4.4 years ago
Chris Saxon (Oracle)
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
10
796
4.1 years ago
Oracle
Adding Multiple Language Support to Analytic Views
This tutorial provides examples of adding multiple language support to analytic views.
Tutorial
analytic views, nls
4
781
5.8 years ago
William Endress (Oracle)
Approximate Query Processing - Getting Started
Approximate Query Processing provides approximate result capabilities in SQL. The motivation behind ...
Tutorial
sql analytics,approximate query processing
6
774
5.9 years ago
Nigel Bayliss (Oracle)
row(s) 1 - 60 of 1137
Next