Oracle
Live SQL
Help
Sign In
Home
SQL Worksheet
My Session
Previous Sessions
Utilization
NLS
Schema
Design
My Scripts
Code Library
Code Library
Breadcrumb
Search
Area
All
SQL Analytics - 45
SQL General - 400
Oracle Text - 5
Data Models - 9
PL/SQL General - 371
Partitioning - 29
Compression - 1
SQL Types - 4
Oracle 12c - 10
Performance and Tuning - 9
Geospatial - 1
NLS - 7
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
291
34888
3 years ago
Mike Hichwa (Oracle)
Hello World
Simple example showing how to write text to the console.
Script
DBMS_OUTPUT, pl/sql
54
4459
3 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
39
3351
3 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
59
1556
3 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
43
1225
3 years ago
Mike Hichwa (Oracle)
Orders and Items Schema
Sample products, orders, and items schema with sample data.
Script
Order Items, schema, data model, orders, items, customers, plsql
31
1154
3 years ago
Mike Hichwa (Oracle)
Simple Explain Plan
This script explains the plan for a query of the sh.sales and sh.products tables.
Script
execution plan
12
898
3 years ago
Oracle
Contacts Schema
Simple schema to use to practice SQL
Script
17
794
3 years ago
Mike Hichwa (Oracle)
Car Database
Database to perform Advanced DML, PL/SQL, Triggers, Procedure and Functions
Script
6
587
12 months ago
Karan
Top N Query
Database 11g top N query syntax, Show top N rows of a query result
Script
TOP-N, top
15
572
3 years ago
Mike Hichwa (Oracle)
IS JSON
Using the is JSON where clause predicate
Script
JSON, IS JSON, 12c
8
569
3 years ago
Mike Hichwa (Oracle)
XML with EMP and DEPT
Basic XML casting example on the standard EMP and DEPT tables
Script
XML, XMLForest
22
506
3 years ago
Mike Hichwa (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
15
463
2.7 years ago
Steven Feuerstein (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
20
351
2.1 years ago
Chris Saxon (Oracle)
Brookstrut Sample Schema
Sample basic store, products, purchases schema with ability to generate data.
Script
BROOKSTRUT, PL/SQL, PLSQL, SQL, data generation
11
304
3 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
8
285
4 months ago
Oracle
DHBW Datenbanken Unit 1 - 10 - GROUP BY und HAVING
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
7
260
2.1 years ago
Schulz
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
8
254
2.9 years ago
Connor Mcdonald (Oracle)
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
17
209
3 years ago
Oracle
DHBW Datenbanken Unit 1 - 07 - Joins, 3 Tables (Artist, Album, Song)
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
4
200
2.1 years ago
Schulz
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
24
192
2.4 years ago
Steven Feuerstein (Oracle)
DHBW Datenbanken Unit 1 - 12 - Subqueries
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
5
184
2 years ago
Schulz
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
8
170
3 years ago
Oracle
Oracle Text Demo
Basic introduction to Oracle Text.
Script
text
12
167
3 years ago
Joel Kallman (Oracle)
DHBW Datenbanken Unit 1 - 08 - Set Operatoren
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
3
156
2.1 years ago
Schulz
Analytics - Ranking part 3
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
1
154
2.8 years ago
Connor Mcdonald (Oracle)
Compute real-earth distances with SQL
This SQL script shows how to use the SDO_GEOM.SDO_DISTANCE function to calculate distances between t...
Script
distance,sql,locator
7
150
3 years ago
Carsten Czarski (Oracle)
DHBW Datenbanken Unit 1 - 04 - Operatoren
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
144
2.1 years ago
Schulz
DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
139
2.1 years ago
Schulz
EXPLAIN PLAN
Use the EXPLAIN PLAN statement to determine the execution plan Oracle Database follows to execute a ...
Script
EXPLAIN PLAN, performance, access path
11
129
3 years ago
Mike Hichwa (Oracle)
Interval Partitioning
Example of interval partitioning by date
Script
8
129
3 years ago
Mike Hichwa (Oracle)
Example Type
Customer Address type made up of a street address, postal code, city, state, country code.
Script
type
1
124
3 years ago
Mike Hichwa (Oracle)
Row-Level Trigger
Creates a table of words and a trigger that strips leading and trailing blanks from each word that i...
Script
4
122
3 years ago
Oracle
DHBW Datenbanken Unit 1 - 03 - AND, NOT und OR
DHBW Datenbanken Unit 1
Script
3
117
2.1 years ago
Schulz
LAG analytic function example
LAG is an analytic function. It provides access to more than one row of a table at the same time wit...
Script
lag
9
116
3 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
7
113
3 years ago
Mike Hichwa (Oracle)
Function Result Cache Demo
Demonstrate the use and performance advantage of function result cache
Script
Result cache PLSQL
12
106
3 years ago
Binuraj Somanathan Nair (http://oracleappsdiary.blogspot.co.uk)
DHBW Datenbanken Unit 1 - 13 - Views
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
105
2 years ago
Schulz
DHBW Datenbanken Unit 1 - 02 - SQL Languages
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
97
2.1 years ago
Schulz
DHBW Datenbanken Unit 1 - 14 - WITH Clause
DHBW, Datenbanken, Vorlesung
Script
2
95
2 years ago
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
2
91
2.4 years ago
Steven Feuerstein (Oracle)
DHBW Datenbanken Unit 1 - 11 - DISTINCT
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
89
2 years ago
Schulz
Max out my storage
Create a table and populate a large number of rows to test the storage constraints of this Live SQL ...
Script
testing
4
89
3 years ago
Mike Hichwa (Oracle)
Analytics - More ranking options
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
5
88
2.8 years ago
Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 16 - Constraints
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
3
86
2 years ago
Schulz
Creating a Composite Range-List Partitioned Table
Administering composite range-list partitioning
Script
7
85
3 years ago
Oracle
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
3
84
2.6 years ago
Steven Feuerstein (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
0
80
2.8 years ago
Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 15 - Tuning, Index, Statistics, Explain Plan
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
4
80
2 years ago
Schulz
Analytics - More complex ranking functions
SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...
Script
1
79
2.8 years ago
Connor Mcdonald (Oracle)
Function and Procedure in Package
A Test PLSQL Package that demonstrates both a Function and a Procedure.
Script
7
76
3 years ago
Hemant K Chitale
Creating Indexes
Indexes are optional structures associated with tables and clusters that allow SQL queries to execut...
Script
index, table, alter
6
74
3 years ago
Oracle
Creating a Range Partitioned Table
Administering range partitioning
Script
5
73
3 years ago
Oracle
First Time Run
sysdate, build a table, populate a table, run a select * from
Script
3
70
3 years ago
That Jeff Smith (Oracle)
DHBW Datenbanken Unit 1 - 06 - Cross Join
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
2
67
2 years ago
Schulz
Enabling and Disabling Tables for the In-Memory Column Store
The In-Memory Column Store (IM column store) is an optional portion of the system global area (SGA) ...
Script
3
66
3 years ago
Oracle
Range Partitioning
Partition by range of values
Script
3
65
3 years ago
Mike Hichwa (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
0
64
2.8 years ago
Connor Mcdonald (Oracle)
Materialized View Log DML Impact
Session to test impact of materialized view log on insert.
Script
2
64
2.2 years ago
KK
DHBW Datenbanken Unit 1 - 05 - Joins v2
DHBW Datenbanken Unit 1
Script
DHBW, Datenbanken, Vorlesung
0
63
5 weeks ago
Schulz
row(s) 1 - 60 of 839
Next