Where can I get SQL for default Oracle's "HR" schema? [closed]
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 questionI'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/
精彩评论