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 - 49
SQL General - 487
Oracle Text - 10
Data Models - 11
PL/SQL General - 480
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
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
843
152,274
6.6 years ago
Mike Hichwa (Oracle)
HR Objects and Data For Live SQL
This script will create a the HR Sample Schema objects and data in your local schema. If you want j...
Script
SQL, HR Schema, Employees Table, Departments Table
534
84,660
3.9 years ago
Oracle
Hello World
Simple example showing how to write text to the console.
Script
DBMS_OUTPUT, pl/sql
84
6,543
6.6 years ago
Mike Hichwa (Oracle)
Baseball Teams and Players
Creates two tables: PLAYERS and TEAMS Teams are World Series teams from 2014: The Kansas City Roy...
Script
87
5,412
6.6 years ago
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
153
3,753
6.6 years ago
Mike Hichwa (Oracle)
Car Database
Database to perform Advanced DML, PL/SQL, Triggers, Procedure and Functions
Script
54
3,142
4.6 years ago
Karan
Simple Explain Plan
This script explains the plan for a query of the sh.sales and sh.products tables.
Script
execution plan
50
2,891
6.6 years ago
Oracle
Orders and Items Schema
Sample products, orders, and items schema with sample data.
Script
Order Items, schema, data model, orders, items, customers, plsql
50
2,409
6.6 years ago
Mike Hichwa (Oracle)
World Population Queries
Aggregation and various queries on shared world population schema data.
Script
AGGREGATION, TOP-N, TOP-10, LEAD, RANK
61
1,570
6.6 years ago
Mike Hichwa (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
27
1,533
6.5 years ago
Connor Mcdonald (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
70
1,479
5.7 years ago
Chris Saxon (Oracle)
Contacts Schema
Simple schema to use to practice SQL
Script
29
1,136
6.6 years ago
Mike Hichwa (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
70
868
6 years ago
Steven Feuerstein (Oracle)
Top N Query
Database 11g top N query syntax, Show top N rows of a query result
Script
TOP-N, top
28
785
6.6 years ago
Mike Hichwa (Oracle)
Analytics - Ranking part 3
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
8
746
6.4 years ago
Connor Mcdonald (Oracle)
XML with EMP and DEPT
Basic XML casting example on the standard EMP and DEPT tables
Script
XML, XMLForest
34
725
6.6 years ago
Mike Hichwa (Oracle)
IS JSON
Using the is JSON where clause predicate
Script
JSON, IS JSON, 12c
11
711
6.6 years ago
Mike Hichwa (Oracle)
19C LISTAGG DISTINCT
The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword....
Script
19c LISTAGG
37
699
3.4 years ago
Oracle
''How did I get here?'' DBMS_UTILITY.FORMAT_CALL_STACK
Use the DBMS_UTILITY.FORMAT_CALL_STACK function to answer the question "How did I get here?". Note t...
Script
call stack
22
593
6.3 years ago
Steven Feuerstein (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
17
563
1.7 years ago
Chris Saxon (Oracle)
Analytics - More ranking options
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
15
533
6.4 years ago
Connor Mcdonald (Oracle)
Analytics - More complex ranking functions
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
9
525
6.4 years ago
Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 10 - GROUP BY und HAVING
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
8
440
5.7 years ago
Matthias K. F. Schulz
Inserting Multiple Rows Using a Single Statement
This example creates three tables and them uses different INSERT statements to insert data into thes...
Script
INSERT
26
429
6.6 years ago
Oracle
Analytics - How null values are treated
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
ranking, nulls, kiss
6
427
6.4 years ago
Connor Mcdonald (Oracle)
ROW_NUMBER(), RANK(), DENSE_RANK() WITH EXAMPLE
ROW_NUMBER(), RANK(), DENSE_RANK() WITH EXAMPLE
Script
15
422
4.7 years ago
SQL for Hierarchical Format
Analytics - Using the PARTITION clause
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, partitioning, multi-column, range
8
418
5.2 years ago
Connor Mcdonald (Oracle)
Oracle Database 11g SQL
Oracle Database 11g SQL Scripts Includes table customers,product_types,products,purchases,employees...
Script
12
416
4.3 years ago
Ba Bunnki
DHBW Datenbanken Unit 1 - 07 - Joins, 3 Tables (Artist, Album, Song)
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
9
402
5.7 years ago
Matthias K. F. Schulz
Analytics - First look at Window functions
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
ranking, kiss, oracle, sql, analytics
6
395
6.3 years ago
Connor Mcdonald (Oracle)
19c JSON_OBJECT
Syntax simplifications are offered for SQL/JSON path expressions, SQL/JSON generation with function ...
Script
19c JSON
14
394
3.4 years ago
Oracle
Analytics - LAG and LEAD functions
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics, lag, lead
11
354
6.2 years ago
Connor Mcdonald (Oracle)
Brookstrut Sample Schema
Sample basic store, products, purchases schema with ability to generate data.
Script
BROOKSTRUT, PL/SQL, PLSQL, SQL, data generation
14
337
6.6 years ago
Mike Hichwa (Oracle)
Analytics - Partition clause with aggregation
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
aggregation, kiss, partition
7
328
6.4 years ago
Connor Mcdonald (Oracle)
Analytics - How to apply predicates
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
ranking, predicates, kiss
4
325
6.4 years ago
Connor Mcdonald (Oracle)
Function and Procedure in Package
A Test PLSQL Package that demonstrates both a Function and a Procedure.
Script
22
321
6.6 years ago
Hemant K Chitale
Change-Logging Trigger
Creates a table, a log table, and a trigger that inserts a row in the log table after any row of the...
Script
14
320
6.6 years ago
Oracle
DHBW Datenbanken Unit 1 - 04 - Operatoren
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
5
317
5.7 years ago
Matthias K. F. Schulz
DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
10
314
5.7 years ago
Matthias K. F. Schulz
DHBW Datenbanken Unit 1 - 12 - Subqueries
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
8
295
5.6 years ago
Matthias K. F. Schulz
Example Type
Customer Address type made up of a street address, postal code, city, state, country code.
Script
type
5
275
6.6 years ago
Mike Hichwa (Oracle)
Oracle Text Demo
Basic introduction to Oracle Text.
Script
text
16
263
6.6 years ago
Joel Kallman (Oracle)
DHBW Datenbanken Unit 1 - 08 - Set Operatoren
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
4
260
5.7 years ago
Matthias K. F. Schulz
DHBW Datenbanken Unit 1 - 03 - AND, NOT und OR
DHBW Datenbanken Unit 1
Script
6
253
5.7 years ago
Matthias K. F. Schulz
DML Trigger Conditional Predicates: INSERTING, UPDATING, DELETING
The triggering event of a DML trigger can be composed of multiple triggering statements. When one of...
Script
conditional predicate,inserting,updating,deleting
7
246
6 years ago
Steven Feuerstein (Oracle)
DHBW Datenbanken Unit 1 - 16 - Constraints
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
5
243
5.6 years ago
Matthias K. F. Schulz
Exceptions Raised in Declaration Section Not Handled Locally
This sometimes surprises a developer new to PL/SQL. The exception section of a PL/SQL block can only...
Script
exception,declaration,unhandled
8
242
6.2 years ago
Steven Feuerstein (Oracle)
add 2 numbers using PL SQL
this is a program to add two numbers using PL/SQL commands.
Script
4
241
4.3 years ago
Harneet Singh
Analytics - The RANGE options for windows
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics, range
6
237
6.3 years ago
Connor Mcdonald (Oracle)
Analytics - Window boundaries
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics, range
3
236
6.3 years ago
Connor Mcdonald (Oracle)
Analytics - Grouping ranges of data
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, oracle, analytics, grouping, ranges
4
235
6.1 years ago
Connor Mcdonald (Oracle)
Analytics - Windows and null values
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics, nulls
5
228
6.2 years ago
Connor Mcdonald (Oracle)
Analytics - Windows and the NTH_VALUE function
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics, nth_value
5
225
6.3 years ago
Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 05 - Joins v2
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
222
3.7 years ago
Matthias K. F. Schulz
Analytics - More window clause examples
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, windows, oracle, analytics
5
211
6.3 years ago
Connor Mcdonald (Oracle)
EXPLAIN PLAN
Use the EXPLAIN PLAN statement to determine the execution plan Oracle Database follows to execute a ...
Script
EXPLAIN PLAN, performance, access path
20
211
6.6 years ago
Mike Hichwa (Oracle)
Hierarchical Queries
Using connect by and connect by prior to perform hierarchical queries using a self referencing forei...
Script
connect by, hierarchical query
13
208
6.6 years ago
Mike Hichwa (Oracle)
MERGE example
This example creates item price table catalog1 to capture the price of various items. A second tab...
Script
merge, WHEN MATCHED
16
206
6.6 years ago
Mike Hichwa (Oracle)
Analytics - PIVOT and UNPIVOT functions
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
kiss, oracle, analytics, pivot, unpivot
5
205
6 years ago
Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 14 - WITH Clause
DHBW, Datenbanken, Vorlesung
Script
3
202
5.6 years ago
Matthias K. F. Schulz
row(s) 1 - 60 of 1057
Next