Oracle database is shipped with several sample schemas. These schemas are models for real-world solutions of common business applications such as human resources and order entry. In this topic, we will look at the human resources (HR) schema entities, or tables.
To learn how to work with HR schema entities, follow these steps:
Employeestable. Type in the following statement and press Enter:
job_idconnects the employee to a job in the
Jobstable and the
manager_idconnects the employee to a manager in the
Jobstable contains a row for each job position. We can display the columns on this table:
Departments(departments in which employees work),
Locations(city and state/province where department is located),
Countries(country of location) and
Regions(region in which country is located, e.g., Germany is in the "Europe" region).