Where can I get SQL for default Oracle's "HR" schema? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 3 years ago.

开发者_JAVA技巧 Improve this question

I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

---

check here the schema is in a zip file

http://code.google.com/p/adf-samples-demos/downloads/detail?name=demoscripts.zip&can=2&q=

---

Just wanted to update this post that the above link won't work:

Try this instead: http://www.oracle.com/technetwork/developer-tools/datamodeler/sample-models-scripts-224531.html

And refer this also: http://st-curriculum.oracle.com/obe/jdev/obe11jdev/11/common/connection11g.htm#t1

Hope this helps!!

---

If practicing using HR Schema is your requirement, you can use the Oracle Live SQL. It has the HR Schema for you to play around with.

https://livesql.oracle.com

---

Old question but high Google page rank, so here goes:

They are hosted by Oracle on Github now (as of 2018): https://github.com/oracle/db-sample-schemas

---

See this link: http://download.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm#sthref33

It's under $ORACLE_HOME/demo/schema/human_resources

---

I was working on a database connected via SQL developer and could not find HR schema. I wanted to create the HR schema using SQL queries. I used below scripts one by one and create the schema with the SYS user:

Check here: https://support.dbagenesis.com/knowledge-base/script-to-create-hr-schema/