# I need sample database for Oracle for practice?
**URL:** https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825
**Category:** In My Humble Opinion
**Created:** [July 11, 2014, 4:59am UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825 "2014-07-11T04:59:59Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@jHensOn](https://boards.straightdope.com/u/jHensOn)
#### Post date: [July 11, 2014, 4:59am UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/1 "2014-07-11T04:59:59Z")
I am new to Oracle. I want to practice more sql query and pl/sql program. I want sample database like northwind, inventory database so that I can practice on that database. Also with list of exercise from this database to practice. In short, i want particlular database with numbers of exercise to solve particular query. Please give me link. thanks in advance
---
### Author:  [@running\_coach](https://boards.straightdope.com/u/running_coach)
#### Post date: [July 11, 2014, 5:02am UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/2 "2014-07-11T05:02:58Z")
Reported for forum change/homework/spam.
---
### Author:  [@Senegoid](https://boards.straightdope.com/u/Senegoid)
#### Post date: [July 11, 2014, 7:34am UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/3 "2014-07-11T07:34:44Z")
Want lots of practice? Design and build your own Oracle database, from scratch, to be a more-or-less clone of Northwind, then import Northwind into that. You could do just some important pieces of it for starters.
---
### Author:  [@QuickSilver](https://boards.straightdope.com/u/QuickSilver)
#### Post date: [July 11, 2014, 12:49pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/4 "2014-07-11T12:49:45Z")
> [@Senegoid](#):
>
> Want lots of practice? Design and build your own Oracle database, from scratch, to be a more-or-less clone of Northwind, then import Northwind into that. You could do just some important pieces of it for starters.
You’re suggesting he code his own RDBMS just to practice some SQL? Man, you are tough on the IT newbs. 😛
---
### Author:  [@Debaser](https://boards.straightdope.com/u/Debaser)
#### Post date: [July 11, 2014, 1:55pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/5 "2014-07-11T13:55:01Z")
[LMGTFY…](http://lmgtfy.com/?q=oracle+sample+database+download)
---
### Author:  [@yoyodyne](https://boards.straightdope.com/u/yoyodyne)
#### Post date: [July 11, 2014, 2:32pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/6 "2014-07-11T14:32:29Z")
You don’t expect them to learn both Oracle and the internet at the same time, do you?
---
### Author:  [@Isilder](https://boards.straightdope.com/u/Isilder)
#### Post date: [July 11, 2014, 7:24pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/7 "2014-07-11T19:24:30Z")
Or dump the northwind as a script and edit it to load into Oracle.
But Oracle does have their own equiv of Northwind , a demo schema used in the material…
> **[Sample Models and Scripts](https://www.oracle.com/database/technologies/appdev/datamodeler-samples.html)**
>
> A set of sample data models and DDL scripts
and
[http://docs.oracle.com/cd/B28359\_01/server.111/b28328/scripts.htm#Cihijfgh](http://docs.oracle.com/cd/B28359_01/server.111/b28328/scripts.htm#Cihijfgh)
---
### Author:  [@Mama\_Zappa](https://boards.straightdope.com/u/Mama_Zappa)
#### Post date: [July 11, 2014, 9:21pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/8 "2014-07-11T21:21:08Z")
The desktop version of Oracle (free) came with several sample tables, as I recall. The interface to edit the data isn’t the best - it’s been a while since I worked with it - but it’s something especially if you don’t have access to a server-based version.
Lots of Oracle textbooks have sample databases available to download - the DDL that is.
Failing that, come up with some simple tool that makes sense in your life. Say, a household inventory: you need a table for things, a table for rooms they belong in, a table for people who own them, a table for addresses of houses, and so on. Make up a household, and play around with producing reports.
---
### Author:  [@Senegoid](https://boards.straightdope.com/u/Senegoid)
#### Post date: [July 11, 2014, 11:13pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/9 "2014-07-11T23:13:46Z")
> [@QuickSilver](#):
>
> You’re suggesting he code his own RDBMS just to practice some SQL? Man, you are tough on the IT newbs. 😛
??? Uh, what? Northwind is a well-known (in some circles, anyway) sample database, not a RDMBS. He could study the structure and design of that database, and then write his own SQL code to build and populate something similar, then write more of his own SQL to do reports and updates or whatever.
---
### Author:  [@Small\_Clanger](https://boards.straightdope.com/u/Small_Clanger)
#### Post date: [July 12, 2014, 1:53pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/10 "2014-07-12T13:53:16Z")
New to Oracle? You Know SQL already? RDBS theory?
Just curious. You want to practice PL/SQL? I don’t think anyone ever wrote any PL/SQL for fun, if you want to learn enough to get _paid_ for it I suggest getting yourself on a proper course. If you just want to learn SQL use something much more light-weight (and free) like MySql.
S. Clanger. Recovering Oracle programmer.
---
### Author:  [@Dewey\_Finn](https://boards.straightdope.com/u/Dewey_Finn)
#### Post date: [July 12, 2014, 5:28pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/11 "2014-07-12T17:28:46Z")
> [@Senegoid](#):
>
> ??? Uh, what? Northwind is a well-known (in some circles, anyway) sample database, not a RDMBS. He could study the structure and design of that database, and then write his own SQL code to build and populate something similar, then write more of his own SQL to do reports and updates or whatever.
Isn’t Northwind the sample database in Microsoft Access? Does Oracle use the same fictional company name, or is the same sample database also used by Oracle?
---
### Author:  [@RaftPeople](https://boards.straightdope.com/u/RaftPeople)
#### Post date: [July 12, 2014, 5:33pm UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/12 "2014-07-12T17:33:02Z")
> [@Dewey\_Finn](#):
>
> Isn’t Northwind the sample database in Microsoft Access? Does Oracle use the same fictional company name, or is the same sample database also used by Oracle?
That poster was stating that the OP could take MS’s Northwind DB and re-create it in Oracle via SQL stmts.
---
### Author:  [@Little\_Pig](https://boards.straightdope.com/u/Little_Pig)
#### Post date: [July 13, 2014, 5:08am UTC](https://boards.straightdope.com/t/i-need-sample-database-for-oracle-for-practice/692825/13 "2014-07-13T05:08:59Z")
> [@Debaser](#):
>
> [LMGTFY…](http://lmgtfy.com/?q=oracle+sample+database+download)
Debaser
Cool.