Sample database schema for Oracle

Question

Are there any sample databases for Oracle like AdventureWorks for MS SQL? I've searched Oracle site but didn't find any sample database.

I don't understand why ORACLE has made it so difficult to get sample database. I work on SQL Server. I want script that can be ran as easy as AdventureWorks in MS SQL ,I don't have SQL*Plus.I am using SQL Developer. — hrishi, Dec 30 '14 at 05:30

APC · Accepted Answer · 2013-06-21T14:59:03.573

8

The Oracle database installation includes scripts to install sample schemas. Find out more.

Many online examples use the extremely simple EMP and DEPT tables. These tables are not part of the documented schemas listed above. Finding the script for the beloved SCOTT/TIGER schema is harder than you might think. The demobld.sql used to be under the sqlplus sub-directory. Then in 10g (I think) they moved the schema to $ORACLE_HOME/admin/rdbms/scott.sql. In 11gR2 it's moved again, to $ORACLE_HOME/admin/rdbms/utlsampl.sql.

edited Jun 21 '13 at 14:59

answered Jan 17 '10 at 16:27

APC

144,005
19
170
281

1

The linked content is missing. – Iain Samuel McLean Elder May 26 '13 at 18:51
@IainElder - I guess Oracle is having a re-org of their docs prior to the launch of version 12c. I've now fixed the broken link. – APC Jun 02 '13 at 12:25

score 5 · Answer 2 · edited May 23 '17 at 11:47

5

This question can be of some help(?).

Good Databases with sample data

edited May 23 '17 at 11:47

Community

1
1

answered Jan 17 '10 at 12:05

Shoban

22,920
8
63
107

score 0 · Answer 3 · answered Jan 19 '19 at 23:35

0

You can run Oracle Live SQL online without Oracle installed. Menu contains:

SQL Worksheet
My Session
Schema. Includes SCOTT, HR, Order Entry (OE) and others.
Quick SQL
My Scripts
Code Library

Contains a search function, scripts, and tutorials.

answered Jan 19 '19 at 23:35

ExcessOperatorHeadspace

318
4
17

Sample database schema for Oracle

3 Answers3