Oracle Live SQL

Help
Sign In

Home
SQL Worksheet
My Session
Schema
Quick SQL
My Scripts
My Tutorials
Code Library

Code Library

Breadcrumb

Search

Area

Category

Types

All

Tutorials

Scripts

Sort By

Date Added

Executions

Name

Likes

Results Per Page

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

142 92,603

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

428 53,750

4 years ago Mike Hichwa (Oracle)
PL/SQL Anonymous Blocks

Define blocks of procedural of code using PL/SQL.

Tutorial

22 14,665

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

97 13,341

1.3 years ago Oracle
Subqueries: Databases for Developers

An introduction to using subqueries in Oracle Database

Tutorial with clause, in, exists

40 10,618

1.5 years ago Oracle
Creating Tables: Databases for Developers

An introduction to creating tables and the types of these available in Oracle Database.

Tutorial create table

20 7,713

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

16 6,487

2.8 years ago Oracle
SQL/JSON Features in Database 12.2

This Tutorial introduces the new JSON-related extensions to SQL and PL/SQL that have been added to O...

Tutorial

11 5,558

2.8 years ago Oracle
Hello World

Simple example showing how to write text to the console.

Script DBMS_OUTPUT, pl/sql

63 5,180

4 years ago Mike Hichwa (Oracle)
Analytic Functions: Databases for Developers

An introduction to analytic functions.

Tutorial analytics

23 4,266

1.5 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

9 4,117

4 years ago Oracle
Baseball Teams and Players

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

Script

54 3,989

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

12 3,808

1.5 years ago Oracle
Updating table data

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

Tutorial

11 3,557

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

13 2,967

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

7 2,732

2.7 years ago Oracle
Hierarchical Queries: Databases for Developers

An introduction to using connect by and recursive with to traverse trees.

Tutorial connect by, recursive with

16 2,322

1.4 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

89 2,225

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

11 2,216

1.4 years ago Oracle
Joining Tables: Databases for Developers

An introduction to the join types available in Oracle Database.

Tutorial join, inner join, outer join, cross join

22 2,051

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

10 1,704

1.5 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

6 1,700

2.8 years ago Oracle
Columns and Data Types: Databases for Developers

An introduction to the various data types available in Oracle Database.

Tutorial create table, alter table

8 1,602

2.1 years ago Oracle
Simple Explain Plan

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

Script execution plan

17 1,557

4 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

35 1,454

4 years ago Mike Hichwa (Oracle)
Union, Minus, and Intersect: Databases for Developers

An introduction to the set operators, union, minus, and intersect

Tutorial union, minus, intersect

7 1,422

1.4 years ago Oracle
Car Database

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

Script

21 1,414

2 years ago Karan
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

15 1,358

1.2 years ago Oracle
World Population Queries

Aggregation and various queries on shared world population schema data.

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

48 1,354

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

2 1,246

2.1 years ago Oracle
Merge: Databases for Developers

An introduction to how to use merge to do insert-or-update logic.

Tutorial merge, upsert

9 1,118

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

13 1,099

2.1 years ago Oracle
Querying Analytic Views

This tutorial provides an introduction to querying hierarchies and analytic views. This is a good s...

Tutorial analytic views, hierarchy, hierarchies

5 1,095

2.8 years ago Oracle
Table Design: Databases for Developers

An introduction to designing database tables.

Tutorial

6 1,043

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

7 985

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

4 955

2.8 years ago Oracle
Contacts Schema

Simple schema to use to practice SQL

Script

21 869

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

2 801

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

33 733

3.1 years ago Chris Saxon (Oracle)
HOL Analytic Functions (Kscope17)

Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of analytic functions i...

Tutorial

1 692

2.7 years ago Oracle
Using Materialized Views With Analytic Views

This tutorial shows how to use materialized views to accelerate queries that select from analytic vi...

Tutorial analytic view, materialized view

1 678

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

6 663

1.4 years ago Oracle
Top N Query

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

Script TOP-N, top

19 635

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

8 615

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

4 612

1.4 years ago Oracle
IS JSON

Using the is JSON where clause predicate

Script JSON, IS JSON, 12c

8 600

4 years ago Mike Hichwa (Oracle)
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

2 597

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

11 572

3.9 years ago Connor Mcdonald (Oracle)
XML with EMP and DEPT

Basic XML casting example on the standard EMP and DEPT tables

Script XML, XMLForest

26 550

4 years ago Mike Hichwa (Oracle)
Adding Multiple Language Support to Analytic Views

This tutorial provides examples of adding multiple language support to analytic views.

Tutorial analytic views, nls

1 516

2.7 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

18 513

3.7 years ago Steven Feuerstein (Oracle)
Removing Rows: Databases for Developers

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

Tutorial delete, truncate

4 500

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

2 478

1.3 years ago Oracle
MATCH_RECOGNIZE - Fraud demo for OracleCODE events

This is a simple demo showing how to use SQL pattern matching for fraud analysis. It is part of a pr...

Tutorial PATTERN MATCHING, MATCH_RECOGNIZE,

2 460

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

1 448

2.8 years ago Oracle
Approximate Query Processing - Getting Started

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

Tutorial sql analytics,approximate query processing

2 417

2.8 years ago Oracle
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,

2 410

3 years ago Oracle
HOL Row Pattern Matching (Kscope17)

Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of row pattern matching...

Tutorial

2 407

2.4 years ago Oracle
MATCH_RECOGNIZE - Log file sessionization analysis

How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis on web l...

Tutorial pattern matching, sessionization, MATCH_RECOGNIZE

2 404

3.5 years ago Oracle
MATCH_RECOGNIZE - Using Built-In Measures

In this tutorial we will review the two built-in measures that are part of MATCH_RECOGNIZE. These me...

Tutorial MATCH_RECOGNZE, pattern matching

3 403

3 years ago Oracle

row(s) 1 - 60 of 1008

© 2019 Oracle Corporation · Privacy · Terms of Use
Oracle Learning Library · Oracle Database Documentation 18c , 12c · Follow on Twitter

Live SQL 19.3.1, running Oracle Database 19c Enterprise Edition - 19.4.0.0.0

Built with love using Oracle APEX