Installing the Sample Objects

In Oracle Application Express, users log in to a workspace. You can think of each workspace as a shared work area that separates your objects, data, and applications into a virtual private database.

Before performing any tasks in this guide, you must create the appropriate sample objects within your workspace. These sample objects are copies of the objects that are typically installed in two schemas:

• Human Resources (HR)

  The HR schema contains information about the employees and the facilities where they work. Each employee has an identification number, email address, job identification code, salary, and manager. Employees are assigned to a department, and each department is associated with one location that has a full address, including the street name, postal code, city, state or province, and country code.

• Order Entry (OE)

  The OE schema tracks product inventories and sales of a company's products, including the product identification number, the product name, the associated associates product category, product descriptions, the weight group (for shipping purposes), the warranty periods, the suppliers, the availability status, and a minimum price.

To create the objects locally in your workspace, import the OEHR Sample Objects application.

Topics:

• Downloading OEHR Sample Objects

• Importing the OEHR Sample Objects

• Viewing Your Database Objects