Sample HR Account

Previous
Previous
Next
Next

Oracle Database XE provides the HR sample user account for use with the examples in this guide. This HR user account is also referred to as the HR schema. A schema is a logical container for the database objects that the user creates.

The HR sample account is set up to be a simple Human Resources division for tracking information on the employees and the facilities. In the HR schema, each employee has an identification number, e-mail address, job identification code, salary, and manager. Some employees earn commissions in addition to their salary. Each job has an identification code that associates it with a job title, a minimum salary, and a maximum salary for the job.

Each employee is assigned to a department, and each department is identified either by a unique department number or a short name. Each department is associated with one location, and each location has a full address that includes the street name, postal code, city, state or province, and the country code.

For information about viewing the database objects in the HR schema, including the structure of the HR tables, see "Managing Database Objects With Object Browser".


See Also:

Oracle Database Sample Schemas for information about the HR sample schema