Lab schema (HR schema) is listed as below (primary keys are underlined):
Regions(region_id, region_name);
Countries(country_id, country_name, region_id);
Locations(location_id, street_address, postal_code, city, state_province, country_id);
Departments(department_id, department_name, manager_id, location_id);
Jobs(job_id, job_title, min_salary, max_salary);
Employees(employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id);
Job_History(employee_id, start_date, end_date, job_id, department_id);
Learning Objectives:
Using C/C++ and oracle OCCI library functions, develop a database application program that:
use the data stored in the schema HR, retrieve and display the information about all the employees who directly or indirectly report to a manager. The manager's employee_id is entered to your program either as a command line argument or interactively. The information to be displayed should include each employee's full name, phone number, and his/her department name. If the employee_id of the manager is not valid, show a proper message.
Use prepared statement in this program.