Breadcrumb

Area

Category

Types

All

Tutorials

Scripts

Sort By

Date Added

Executions

Name

Likes

Results Per Page

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

375 46,859

3.7 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

50 6,838

12 months ago Oracle
Hello World

Simple example showing how to write text to the console.

Script DBMS_OUTPUT, pl/sql

61 4,972

3.7 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

49 3,817

3.7 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

76 1,978

3.7 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

16 1,347

3.7 years ago Oracle
World Population Queries

Aggregation and various queries on shared world population schema data.

Script AGGREGATION, TOP-N, TOP-10, LEAD, RANK

46 1,310

3.7 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

34 1,288

3.7 years ago Mike Hichwa (Oracle)
Car Database

Database to perform Advanced DML, PL/SQL, Triggers, Procedure and Functions

Script

16 1,153

1.7 years ago Karan
Contacts Schema

Simple schema to use to practice SQL

Script

21 838

3.7 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

26 643

2.8 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

19 613

3.7 years ago Mike Hichwa (Oracle)
IS JSON

Using the is JSON where clause predicate

Script JSON, IS JSON, 12c

8 586

3.7 years ago Mike Hichwa (Oracle)
XML with EMP and DEPT

Basic XML casting example on the standard EMP and DEPT tables

Script XML, XMLForest

24 543

3.7 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

18 493

3.4 years ago Steven Feuerstein (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

10 434

3.6 years ago Connor Mcdonald (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

34 322

3.1 years ago Steven Feuerstein (Oracle)
Brookstrut Sample Schema

Sample basic store, products, purchases schema with ability to generate data.

Script BROOKSTRUT, PL/SQL, PLSQL, SQL, data generation

12 316

3.7 years ago Mike Hichwa (Oracle)
DHBW Datenbanken Unit 1 - 10 - GROUP BY und HAVING

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

7 284

2.8 years ago Schulz
Analytics - Ranking part 3

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

Script

2 258

3.5 years ago Connor Mcdonald (Oracle)
Oracle Text Demo

Basic introduction to Oracle Text.

Script text

14 227

3.7 years ago Joel Kallman (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

19 226

3.7 years ago Oracle
DHBW Datenbanken Unit 1 - 07 - Joins, 3 Tables (Artist, Album, Song)

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

4 224

2.8 years ago Schulz
DHBW Datenbanken Unit 1 - 12 - Subqueries

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

5 201

2.7 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

9 185

3.7 years ago Oracle
Analytics - More complex ranking functions

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

Script

2 184

3.5 years ago Connor Mcdonald (Oracle)
Example Type

Customer Address type made up of a street address, postal code, city, state, country code.

Script type

2 178

3.7 years ago Mike Hichwa (Oracle)
DHBW Datenbanken Unit 1 - 08 - Set Operatoren

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

3 164

2.8 years ago Schulz
Analytics - More ranking options

SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. ...

Script

6 161

3.5 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 161

3.7 years ago Carsten Czarski (Oracle)
19C LISTAGG DISTINCT

The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword....

Script 19c LISTAGG

13 153

5 months ago 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

13 150

3.7 years ago Mike Hichwa (Oracle)
DHBW Datenbanken Unit 1 - 04 - Operatoren

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

2 147

2.8 years ago Schulz
ROW_NUMBER(), RANK(), DENSE_RANK() WITH EXAMPLE

ROW_NUMBER(), RANK(), DENSE_RANK() WITH EXAMPLE

Script

3 146

1.8 years ago SQL for Hierarchical Format
DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

2 141

2.8 years ago Schulz
DHBW Datenbanken Unit 1 - 15 - Tuning, Index, Statistics, Explain Plan

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

5 140

2.7 years ago Schulz
Interval Partitioning

Example of interval partitioning by date

Script

8 139

3.7 years ago Mike Hichwa (Oracle)
DHBW Datenbanken Unit 1 - 16 - Constraints

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

3 137

2.7 years ago Schulz
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

2 133

3.5 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

1 131

3.5 years ago Connor Mcdonald (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 130

3.7 years ago 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 129

3.7 years ago Mike Hichwa (Oracle)
Function Result Cache Demo

Demonstrate the use and performance advantage of function result cache

Script Result cache PLSQL

13 125

3.7 years ago Binuraj Somanathan Nair (http://oracleappsdiary.blogspot.co.uk)
DHBW Datenbanken Unit 1 - 03 - AND, NOT und OR

DHBW Datenbanken Unit 1

Script

3 121

2.8 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

10 121

3.7 years ago Mike Hichwa (Oracle)
19c JSON_OBJECT

Syntax simplifications are offered for SQL/JSON path expressions, SQL/JSON generation with function ...

Script 19c JSON

7 117

5 months 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 116

3.3 years ago Steven Feuerstein (Oracle)
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

3 111

3.1 years ago Steven Feuerstein (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

2 110

3.3 years ago Connor Mcdonald (Oracle)
Bitmap vs. B-tree Index Comparison

A comparison between single column B-tree vs. bitmap indexes.

Script index, bitmap

7 109

1.9 years ago Chris Saxon (Oracle)
DHBW Datenbanken Unit 1 - 13 - Views

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

2 106

2.7 years ago Schulz
Function and Procedure in Package

A Test PLSQL Package that demonstrates both a Function and a Procedure.

Script

8 106

3.7 years ago Hemant K Chitale
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

1 103

3.4 years ago Connor Mcdonald (Oracle)
DHBW Datenbanken Unit 1 - 02 - SQL Languages

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

2 99

2.8 years ago Schulz
DHBW Datenbanken Unit 1 - 14 - WITH Clause

DHBW, Datenbanken, Vorlesung

Script

2 98

2.7 years ago Schulz
DHBW Datenbanken Unit 1 - 11 - DISTINCT

DHBW Datenbanken Unit 1

Script DHBW, Datenbanken, Vorlesung

2 95

2.7 years ago Schulz
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

1 91

3.5 years ago Connor Mcdonald (Oracle)
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 91

3.7 years ago Mike Hichwa (Oracle)
Creating a Composite Range-List Partitioned Table

Administering composite range-list partitioning

Script

7 90

3.7 years ago Oracle
Creating Indexes

Indexes are optional structures associated with tables and clusters that allow SQL queries to execut...

Script index, table, alter

7 87

3.7 years ago Oracle

row(s) 1 - 60 of 917

Code Library

Breadcrumb

EMP and DEPT

HR Objects and Data For Live SQL

Hello World

Baseball Teams and Players

SQL Joins

Simple Explain Plan

World Population Queries

Orders and Items Schema

Car Database

Contacts Schema

Pivot and unpivot examples using Olympic data

Top N Query

IS JSON

XML with EMP and DEPT

''How did I get here?'' DBMS_UTILITY.FORMAT_CALL_STACK

Analytics - Ranking rows across an entire table

Different Types of Cursors in PL/SQL

Brookstrut Sample Schema

DHBW Datenbanken Unit 1 - 10 - GROUP BY und HAVING

Analytics - Ranking part 3

Oracle Text Demo

Inserting Multiple Rows Using a Single Statement

DHBW Datenbanken Unit 1 - 07 - Joins, 3 Tables (Artist, Album, Song)

DHBW Datenbanken Unit 1 - 12 - Subqueries

Change-Logging Trigger

Analytics - More complex ranking functions

Example Type

DHBW Datenbanken Unit 1 - 08 - Set Operatoren

Analytics - More ranking options

Compute real-earth distances with SQL

19C LISTAGG DISTINCT

EXPLAIN PLAN

DHBW Datenbanken Unit 1 - 04 - Operatoren

ROW_NUMBER(), RANK(), DENSE_RANK() WITH EXAMPLE

DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf

DHBW Datenbanken Unit 1 - 15 - Tuning, Index, Statistics, Explain Plan

Interval Partitioning

DHBW Datenbanken Unit 1 - 16 - Constraints

Analytics - How null values are treated

Analytics - How to apply predicates

Row-Level Trigger

Hierarchical Queries

Function Result Cache Demo

DHBW Datenbanken Unit 1 - 03 - AND, NOT und OR

LAG analytic function example

19c JSON_OBJECT

Exceptions Raised in Declaration Section Not Handled Locally

DML Trigger Conditional Predicates: INSERTING, UPDATING, DELETING

Analytics - LAG and LEAD functions

Bitmap vs. B-tree Index Comparison

DHBW Datenbanken Unit 1 - 13 - Views

Function and Procedure in Package

Analytics - First look at Window functions

DHBW Datenbanken Unit 1 - 02 - SQL Languages

DHBW Datenbanken Unit 1 - 14 - WITH Clause

DHBW Datenbanken Unit 1 - 11 - DISTINCT

Analytics - Partition clause with aggregation

Max out my storage

Creating a Composite Range-List Partitioned Table

Creating Indexes