本教程向您介绍oracle示例数据库，并提供链接供下载。
我们为您提供一个名为 ot 的oracle示例数据库，它基于全球虚拟公司，销售计算机硬件，包括存储，主板，ram，视频卡和cpu。
公司保存产品信息，如：名称，描述标准成本，标价，产品线。它还跟踪所有产品的库存信息，包括产品可用的仓库。由于该公司在全球运营，因此在世界各地拥有仓库。
公司记录所有客户信息，包括姓名，地址和网站。 每个客户至少有一个联系人，包括姓名，电子邮件和电话等详细信息。公司还对每位客户设置了信用限额，以限制客户可能欠的金额。
只要客户发出采购订单，就会在数据库中创建具有待处理状态的销售订单。当公司运送订单时，订单状态变成 - 运送。如果客户取消订单，则订单状态将被 - 取消。
除销售信息外，员工数据还记录了一些基本信息，如姓名，电子邮件，电话，职位，经理和雇用日期。
以下举例说明示例数据库图表：
| 表名称 | 描述 | 记录 |
|---|---|---|
contact |
存储客户的联系人信息 | 319条记录 |
countries |
存储国家信息 | 25条记录 |
customers |
存储客户的信息 | 319条记录 |
employees |
存储员工的信息 | 107条记录 |
inventories |
存储产品的库存信息 | 1112条记录 |
locations |
仓库的地点 | 23条记录 |
orders |
存储订单主要信息 | 105条记录 |
order_items |
存储订单行项目 | 665条记录 |
product_categories |
存储产品类别 | 5条记录 |
products |
存储产品信息 | 288条记录 |
regions |
存储公司经营的地区 | 4条记录 |
warehouses |
存储仓库信息 | 9条记录 |
以zip文件格式下载以下示例数据库：
下载文件后，然后提取它。该zip文件包含以下的sql文件：
以上文件可通过加入 oracle数据库技术qq群(175248146)，从群文件里找到示例数据库(oraok.com)_11g.v1.zip文件并下载。
以下是用于创建数据库对象的语句。
-- regions
create table regions
(
region_id number generated by default as identity
start with 5 primary key,
region_name varchar2( 50 ) not null
);
-- countries table
create table countries
(
country_id char( 2 ) primary key ,
country_name varchar2( 40 ) not null,
region_id number ,
constraint fk_countries_regions foreign key( region_id ) references regions( region_id ) on delete cascade
);
-- location
create table locations
(
location_id number generated by default as identity start with 24
primary key ,
address varchar2( 255 ) not null,
postal_code varchar2( 20 ) ,
city varchar2( 50 ) ,
state varchar2( 50 ) ,
country_id char( 2 ) ,
constraint fk_locations_countries
foreign key( country_id )
references countries( country_id )
on delete cascade
);
-- warehouses
create table warehouses
(
warehouse_id number
generated by default as identity start with 10
primary key,
warehouse_name varchar( 255 ) ,
location_id number( 12, 0 ),
constraint fk_warehouses_locations foreign key( location_id ) references locations( location_id ) on delete cascade
);
-- employees
create table employees
(
employee_id number
generated by default as identity start with 108
primary key,
first_name varchar( 255 ) not null,
last_name varchar( 255 ) not null,
email varchar( 255 ) not null,
phone varchar( 50 ) not null ,
hire_date date not null ,
manager_id number( 12, 0 ) ,
job_title varchar( 255 ) not null,
constraint fk_employees_manager foreign key( manager_id ) references employees( employee_id ) on delete cascade
);
-- product category
create table product_categories
(
category_id number
generated by default as identity start with 6
primary key,
category_name varchar2( 255 ) not null
);
-- products table
create table products
(
product_id number
generated by default as identity start with 289
primary key,
product_name varchar2( 255 ) not null,
description varchar2( 2000 ) ,
standard_cost number( 9, 2 ) ,
list_price number( 9, 2 ) ,
category_id number not null ,
constraint fk_products_categories foreign key( category_id ) references product_categories( category_id ) on delete cascade
);
-- customers
create table customers
(
customer_id number
generated by default as identity start with 320
primary key,
name varchar2( 255 ) not null,
address varchar2( 255 ) ,
website varchar2( 255 ) ,
credit_limit number( 8, 2 )
);
-- contacts
create table contacts
(
contact_id number
generated by default as identity start with 320
primary key,
first_name varchar2( 255 ) not null,
last_name varchar2( 255 ) not null,
email varchar2( 255 ) not null,
phone varchar2( 20 ) ,
customer_id number ,
constraint fk_contacts_customers foreign key( customer_id ) references customers( customer_id ) on delete cascade
);
-- orders table
create table orders
(
order_id number
generated by default as identity start with 106
primary key,
customer_id number( 6, 0 ) not null,
status varchar( 20 ) not null ,
salesman_id number( 6, 0 ) ,
order_date date not null ,
constraint fk_orders_customers foreign key( customer_id ) references customers( customer_id ) on delete cascade,
constraint fk_orders_employees foreign key( salesman_id ) references employees( employee_id ) on delete set null
);
-- order items
create table order_items
(
order_id number( 12, 0 ) ,
item_id number( 12, 0 ) ,
product_id number( 12, 0 ) not null ,
quantity number( 8, 2 ) not null ,
unit_price number( 8, 2 ) not null ,
constraint pk_order_items primary key( order_id, item_id ),
constraint fk_order_items_products foreign key( product_id ) references products( product_id ) on delete cascade,
constraint fk_order_items_orders foreign key( order_id ) references orders( order_id ) on delete cascade
);
-- inventories
create table inventories
(
product_id number( 12, 0 ) ,
warehouse_id number( 12, 0 ) ,
quantity number( 8, 0 ) not null,
constraint pk_inventories primary key( product_id, warehouse_id ),
constraint fk_inventories_products foreign key( product_id ) references products( product_id ) on delete cascade,
constraint fk_inventories_warehouses foreign key( warehouse_id ) references warehouses( warehouse_id ) on delete cascade
);
在本教程中，我们介绍了oracle示例数据库并展示了如何下载它。现在，您应该准备好在oracle数据库服务器中创建示例数据库以供接下来的章节中练习。
