Oracle 9i. Sample Schemas

Oracle has been using the schema SCOTT with its two prominent tables EMP and DEPT tables for a long time. With advances in Oracle’s technology, these tables have become inadequate to show even the most basic features of the Oracle database and other Oracle products. As a result, many other schemas have been created over the years to suit the needs of product documentation, courseware, and software development and application demos.

---

Table of contents :
Send Us Your Comments……Page 5
Preface……Page 7
1 Installation……Page 13
Using the Database Configuration Assistant……Page 14
Prerequisites……Page 15
Schema Dependencies……Page 16
Installing the Order Entry (OE) Schema and its Online Catalog (OC) Subschema……Page 17
Installing the Queued Shipping (QS) Schemas……Page 20
Installing the Sales History (SH) Schema……Page 21
Resetting the Sample Schemas……Page 22
2 Rationale……Page 25
Human Resources (HR)……Page 26
Order Entry (OE)……Page 27
Queued Shipping (QS)……Page 28
Sales History (SH)……Page 29
3 Diagrams……Page 31
4 Oracle9i Sample Schema Scripts……Page 39
mksample.sql……Page 40
hr_analz.sql……Page 42
hr_code.sql……Page 43
hr_comnt.sql……Page 45
hr_cre.sql……Page 50
hr_dn_c.sql……Page 58
hr_dn_d.sql……Page 72
hr_drop.sql……Page 73
hr_idx.sql……Page 74
hr_main.sql……Page 76
oc_comnt.sql……Page 78
oc_cre.sql……Page 79
oc_drop.sql……Page 87
oc_main.sql……Page 88
oe_analz.sql……Page 89
oe_comnt.sql……Page 90
oe_cre.sql……Page 94
oe_drop.sql……Page 103
oe_idx.sql……Page 104
oe_main.sql……Page 105
oe_views.sql……Page 108
pm_analz.sql……Page 110
pm_cre.sql……Page 111
pm_main.sql……Page 114
qs_adm.sql……Page 118
qs_cbadm.sql……Page 120
qs_cre.sql……Page 122
qs_cs.sql……Page 124
qs_drop.sql……Page 126
qs_es.sql……Page 132
qs_main.sql……Page 134
qs_os.sql……Page 143
qs_run.sql……Page 145
qs_ws.sql……Page 155
sh_analz.sql……Page 158
sh_comnt.sql……Page 159
sh_cons.sql……Page 165
sh_cre.sql……Page 166
sh_cremv.sql……Page 175
sh_drop.sql……Page 177
sh_hiera.sql……Page 178
sh_idx.sql……Page 182
sh_main.sql……Page 184
sh_olp_c.sql……Page 187
sh_olp_d.sql……Page 238