Table of Contents

• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Introduction to Sample Schemas
  • 1.1 About the Sample Schemas
  • 1.2 Design Principles for Sample Schemas
  • 1.3 Customer Benefits of Sample Schemas
  • 1.4 Overview of the Sample Schemas
    • 1.4.1 HR Sample Schema
    • 1.4.2 OE Sample Schema
    • 1.4.3 OC Sample Schema
    • 1.4.4 PM Sample Schema
    • 1.4.5 IX Sample Schema
    • 1.4.6 SH Sample Schema
• 2 Installing Sample Schemas
  • 2.1 Installing HR Schema Only
    • 2.1.1 Installing HR Schema Using Database Configuration Assistant
    • 2.1.2 Manually Installing the HR Schema
    • 2.1.3 Uninstalling HR Schema
  • 2.2 Installing Sample Schemas from GitHub
    • 2.2.1 Resetting Sample Schemas
    • 2.2.2 Uninstalling Sample Schemas
• 3 Schema Diagrams
  • 3.1 Sample Schema Diagrams
• 4 Sample Schema Scripts and Object Descriptions
  • 4.1 Master Script for Sample Schemas
    • 4.1.1 mksample.sql
  • 4.2 HR Sample Schema Scripts and Objects
  • 4.3 HR Sample Schema Table Descriptions
    • 4.3.1 Table HR.COUNTRIES
    • 4.3.2 Table HR.DEPARTMENTS
    • 4.3.3 Table HR.EMPLOYEES
    • 4.3.4 Table HR.JOBS
    • 4.3.5 Table HR.JOB_HISTORY
    • 4.3.6 Table HR.LOCATIONS
    • 4.3.7 Table HR.REGIONS
  • 4.4 OE Sample Schema Scripts and Objects
  • 4.5 OE Sample Schema Table Descriptions
    • 4.5.1 Table OE.CUSTOMERS
    • 4.5.2 Table OE.INVENTORIES
    • 4.5.3 Table OE.ORDERS
    • 4.5.4 Table OE.ORDER_ITEMS
    • 4.5.5 Table OE.PRODUCT_DESCRIPTIONS
    • 4.5.6 Table OE.PRODUCT_INFORMATION
    • 4.5.7 Table OE.WAREHOUSES
    • 4.5.8 Table OE.PURCHASEORDER
  • 4.6 PM Sample Schema Scripts and Objects
  • 4.7 PM Sample Schema Table Descriptions
    • 4.7.1 Table PM.ONLINE_MEDIA
    • 4.7.2 Table PM.PRINT_MEDIA
  • 4.8 IX Sample Schema Scripts and Objects
  • 4.9 IX Sample Schema Table Descriptions
    • 4.9.1 Table IX.ORDERS_QUEUETABLE
    • 4.9.2 Table IX.STREAMS_QUEUE_TABLE
  • 4.10 SH Sample Schema Scripts and Objects
  • 4.11 SH Sample Schema Table Descriptions
    • 4.11.1 Table SH.CHANNELS
    • 4.11.2 Table SH.COSTS
    • 4.11.3 Table SH.COUNTRIES
    • 4.11.4 Table SH.CUSTOMERS
    • 4.11.5 Table SH.PRODUCTS
    • 4.11.6 Table SH.PROMOTIONS
    • 4.11.7 Table SH.SALES
    • 4.11.8 Table SH.TIMES
• Index