Where can I get SQL for the default Oracle "HR" schema?

I am studying an Oracle database and should do some exercises using the default "HR" schema. But I think that the data in my tables change from the default values โ€‹โ€‹(many students have access to the database and may be someone else's data). Where can I get SQL to build the default HR schema?

+2
source share
4 answers

Just wanted to update this post so the link above doesn't work:

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

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

Hope this helps!

+2
source

If you are using HR Schema practice, you can use Oracle Live SQL. He has an HR Schema for you to play with.

https://livesql.oracle.com

+1
source

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

Under $ORACLE_HOME/demo/schema/human_resources

0
source

Source: https://habr.com/ru/post/1304235/


All Articles