开发者

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/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜