Table of 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
    • CO Sample Schema
    • SH Sample Schema
    • OE Sample Schema
    • OC Sample Schema
    • PM Sample Schema
• 2 Installation of the Sample Schemas
  • Installing the Sample Schemas
  • Resetting Sample Schemas
  • Uninstalling Sample Schemas
• 3 Schema Diagrams
  • Sample Schema Diagrams
• 4 Sample Schema Scripts and Object Descriptions
  • 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
  • CO Sample Schema Scripts and Objects
  • CO Sample Schema Table Descriptions
    • Table CO.CUSTOMERS
    • Table CO.STORES
    • Table CO.PRODUCTS
    • Table CO.ORDERS
    • Table CO.ORDER_ITEMS
    • Table CO.SHIPMENTS
    • Table CO.INVENTORY
  • 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
  • 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.PRINT_MEDIA
• Index