About the HR Schema

Contact Us or call 1-877-932-8228
About the HR Schema

About the HR Schema

  • Oracle provides sample schemas as a common platform for examples.
  • Oracle documentation is based on the sample schemas.
  • The HR (Human Resources) schema will be used for this course.
  • Employees
  • Departments
  • Jobs
  • Job History
  • Locations
  • Countries
  • Regions

A view (emp_details_view) is also provided as a useful summarization of commonly joined tables.

Sample Schemas

Oracle provides sample schemas as a common platform for examples.

Oracle documentation is based on the sample schemas.

The HR (Human Resources) schema will be used for this course.

HR Schema Entities

The HR Schema includes the following tables:

  • Employees
  • Departments
  • Jobs
  • Job History
  • Locations
  • Countries
  • Regions

A view (emp_details_view) is also provided as a useful summarization of commonly joined tables.

Next