Table Of Content
Sample Oracle Database for Learning SQL
View more Tutorials:
LearningSQL is a small database, used as an example in the instructions of learning SQL on the website of o7planning. There are 3 version on Databases:
- Oracle
- MySQL
- SQLServer.
In this document, I will instruct you to create this database on Oracle.
This database is used in the documentation to learn SQL (Oracle) at:
Download script at:
With Oracle, you just need to care about the file:
- LearningSQL-Oracle-Script.sql

There are two ways to create SCHEMA: LearningSQL
- Using SQL Plus
- Using visual tools.


Run 2 commands:
-- Create Schema named learningsql, password 1234 Create user learningsql identified by 1234; -- For learning purposes: -- Grant highest privilege DBA (DB Admin) for the newly created user. grant dba to learningsql;

Connect to the newly created SCHEMA:
-- Connect to Schema -- Syntax: connect <user>/<pass>@<sid> connect learningsql/1234@db11g;

Run Script:
-- Run Script file in SQL Plus @F:\LEARNING_SQL\LearningSQL-Oracle-Script.sql

Script run successfully:

On the visual tools (Here I use PL/SQL Developer), connected to the user with DBA authority (for example: system).
See more:

Execute script to create schema: learningsql.
-- Create schema named learningsql Create user learningsql identified by 1234; -- For learning purposes: -- Grant highest privilege DBA (DB Admin) for the newly created user. grant dba to learningsql;

Connect to Schema you just created:

Copy content of LearningSQL-Oracle-Script.sql into PL/SQL Developer and execute.

Create Schema success.

LearningSQL is a small database simulating the data of a bank:
Table Name | Description |
ACCOUNT | The table saves the bank accounts. Each of customer can register multiple accounts each of which corresponds to a product type provided by the bank. (See more: PRODUCT) |
ACC_TRANSACTION | The table saves the transaction history between the bank and a certain account. |
BRANCH | The branch of bank. |
BUSSINESS | |
CUSTOMER | The table of customers |
DEPARTMENT | The department table of bank |
EMPLOYEE | The employee table of bank |
OFFICER | |
PRODUCT | The products and services of bank, such as:
|
PRODUCT_TYPE | The types of products and services, such as:
|










