Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

oracle

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?

like image 275
Dmitry Avatar asked Dec 07 '22 04:12

Dmitry


2 Answers

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=

like image 139
user1946695 Avatar answered Feb 04 '23 04:02

user1946695


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!!

like image 26
Harshal Malshe Avatar answered Feb 04 '23 06:02

Harshal Malshe