Code Library - Oracle Live SQL

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,346 323,333

9.7 years ago Mike Hichwa (Oracle)

Script

EMP and DEPT

Example EMP and DEPT tables. Classic Oracle tables with 4 departments and 14 employees. Includes a...

EMP, DEPT, JOIN, referential integrity

1,322 316,939

9.7 years ago Mike Hichwa (Oracle)

Script

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...

SQL, HR Schema, Employees Table, Departments Table

1,088 208,477

7 years ago Oracle

Tutorial

PL/SQL Anonymous Blocks

Define blocks of procedural code using PL/SQL.

249 46,938

9.7 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

217 41,261

7.8 years ago Chris Saxon (Oracle)

Tutorial

Analytic Functions: Databases for Developers

An introduction to analytic functions.

analytics

525 39,162

7.1 years ago Chris Saxon (Oracle)

Tutorial

Subqueries: Databases for Developers

An introduction to using subqueries in Oracle Database

with clause, in, exists

271 28,654

7.2 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

208 15,059

6.9 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

134 14,344

8.5 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

69 11,474

8.5 years ago Roger Ford (Oracle)

Script

Baseball Teams and Players

Creates two tables: PLAYERS and TEAMS Teams are World Series teams from 2014: The Kansas City Roy...

123 10,196

9.7 years ago 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

75 9,906

9.7 years ago Mike Hichwa (Oracle)

Tutorial

Updating table data

This tutorial demonstrates different variations of the UPDATE statement. It includes examples of bas...

73 9,803

9.7 years ago Oracle

Script

Hello World

Simple example showing how to write text to the console.

DBMS_OUTPUT, pl/sql

103 7,417

9.7 years ago Mike Hichwa (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

87 7,054

7.1 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

91 6,877

7.1 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

72 6,566

7.2 years ago Chris Saxon (Oracle)

Script

Car Database

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

94 6,399

7.7 years ago Karan

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

104 5,441

6.9 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

94 5,367

7.1 years ago Chris Saxon (Oracle)

Script

SQL Joins

SQL Join query examples, used to select rows from multiple tables using a join key.

SELF JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN

194 5,154

9.7 years ago Mike Hichwa (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

54 4,602

8.4 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

67 4,561

7.8 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

68 4,333

7.2 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

89 4,291

7.1 years ago Chris Saxon (Oracle)

Script

Simple Explain Plan

This script explains the plan for a query of the sh.sales and sh.products tables. Both statements m...

Orders and Items Schema

Sample products, orders, and items schema with sample data.

Order Items, schema, data model, orders, items, customers, plsql

63 3,806

9.7 years ago Mike Hichwa (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

42 3,492

8.5 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

80 3,415

6.1 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

68 3,278

7.8 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

34 3,038

6.9 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

47 2,802

7 years ago Chris Saxon (Oracle)

Tutorial

Table Design: Databases for Developers

An introduction to designing database tables.

33 2,435

6.9 years ago Chris Saxon (Oracle)

Script

Analytics - Ranking rows across an entire table

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

ranking, kiss

34 2,340

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

23 2,197

7.8 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,111

8.5 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

25 2,087

8.5 years ago William Endress (Oracle)

Script

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...

pivot unpivot

89 1,906

8.8 years ago Chris Saxon (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

30 1,820

6.9 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

13 1,736

8.5 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

29 1,716

7.1 years ago Steven Feuerstein

Script

World Population Queries

Aggregation and various queries on shared world population schema data.

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

66 1,692

9.7 years ago Mike Hichwa (Oracle)

Tutorial

Removing Rows: Databases for Developers

An introduction to how to remove rows from a table using delete and truncate.

delete, truncate

27 1,689

6.8 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

33 1,614

7.1 years ago Steven Feuerstein

Script

Contacts Schema

Simple schema to use to practice SQL

37 1,421

9.7 years ago Mike Hichwa (Oracle)

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

12 1,404

8.5 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

40 1,396

5.2 years ago Chris Saxon (Oracle)

Script

Different Types of Cursors in PL/SQL

An exploration into the different ways you can define and use cursors (pointers to SQL result sets) ...

cursor

97 1,391

9.2 years ago Steven Feuerstein

Script

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...

match_recognize, SQL Macro

40 1,345

4.8 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...

20 1,279

8.4 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,175

8.5 years ago William Endress (Oracle)

Script

19C LISTAGG DISTINCT

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

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,077

8.7 years ago Keith Laker (Oracle)

Script

Analytics - Ranking part 3

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

13 1,068

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

13 1,058

6.7 years ago 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 973

7 years ago Chris Saxon (Oracle)

Tutorial

Approximate Query Processing - Getting Started

Approximate Query Processing provides approximate result capabilities in SQL. The motivation behind ...

sql analytics,approximate query processing

9 970

8.5 years ago Nigel Bayliss (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

11 967

8.5 years ago Keith Laker (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 967

8.4 years ago William Endress (Oracle)

Script

Top N Query

Database 11g top N query syntax, Show top N rows of a query result

TOP-N, top

36 929

9.7 years ago Mike Hichwa (Oracle)