Search notes:

sql-mysteries for Oracle

sql-mysteries is an SQL quiz, developped for an SQLite database, that is meant to practise SQL skills.
sql-mysteries for Oracle is a port of this SQLite database to Oracle.

Instructions

The instructions are essentially the same as those of described in the walkthrough of the original:
A crime has taken place and the detective needs your help. The detective gave you the crime scene report, but you somehow lost it. You vaguely remember that the crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City.
Your first step to solving the mystery is to retrieve the corresponding crime scene report from the police department’s database.
All the clues to this mystery are buried in the database's tables, and you need to use SQL to navigate through this vast network of information.

Scripts to create the database

The database and the release files are created with the following three shell scripts (which must be executed in order):
01-get-original-data.sh Clones the original github repository and creates CSV files from the SQLite database.
02-load-data.sh Creates the sql_myseries schema (load-data/create-schema.sql) and the required tables (load-data/create-tables.sql). Then uses SQL*Loader to load the CSV files into the sql_mysteries` tables.
03-dump-insert-statemehts.sh Creates SQL files (scripts) containing insert statements to load the data into another database. Meant for environments where SQL*Loader is not readily available. The result of this step (these insert scripts and create-tables.sql) can be downloaded from this zip file.

Links

sql-mysteries for Oracle is hosted in this Github repository.

Index