1/19

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Sample Schemas

• About the Sample Schemas
• Design Principles for Sample Schemas
• Customer Benefits of Sample Schemas
• Overview of the Sample Schemas
  • HR Sample Schema
  • OE Sample Schema
  • OC Sample Schema
  • PM Sample Schema
  • IX Sample Schema
  • SH Sample Schema

2 Installing Sample Schemas

• Installing HR Schema Only
  • Installing HR Schema Using Database Configuration Assistant
  • Manually Installing the HR Schema
  • Uninstalling HR Schema
• Installing Sample Schemas from GitHub
  • Resetting Sample Schemas
  • Uninstalling Sample Schemas

3 Schema Diagrams

• Sample Schema Diagrams

4 Sample Schema Scripts and Object Descriptions

• Master Script for Sample Schemas
  • mksample.sql
• HR Sample Schema Scripts and Objects
• HR Sample Schema Table Descriptions
  • Table HR.COUNTRIES
  • Table HR.DEPARTMENTS
  • Table HR.EMPLOYEES
  • Table HR.JOBS
  • Table HR.JOB_HISTORY
  • Table HR.LOCATIONS
  • Table HR.REGIONS
• OE Sample Schema Scripts and Objects
• OE Sample Schema Table Descriptions
  • Table OE.CUSTOMERS
  • Table OE.INVENTORIES
  • Table OE.ORDERS
  • Table OE.ORDER_ITEMS
  • Table OE.PRODUCT_DESCRIPTIONS
  • Table OE.PRODUCT_INFORMATION
  • Table OE.WAREHOUSES
  • Table OE.PURCHASEORDER
• PM Sample Schema Scripts and Objects
• PM Sample Schema Table Descriptions
  • Table PM.ONLINE_MEDIA
  • Table PM.PRINT_MEDIA
• IX Sample Schema Scripts and Objects
• IX Sample Schema Table Descriptions
  • Table IX.ORDERS_QUEUETABLE
  • Table IX.STREAMS_QUEUE_TABLE
• SH Sample Schema Scripts and Objects
• SH Sample Schema Table Descriptions
  • Table SH.CHANNELS
  • Table SH.COSTS
  • Table SH.COUNTRIES
  • Table SH.CUSTOMERS
  • Table SH.PRODUCTS
  • Table SH.PROMOTIONS
  • Table SH.SALES
  • Table SH.TIMES

Index