First problem:Using your COPIES of the employee and department tables provided by Oracle or using similar tables that provide employee, salary, job and dept in one table and dept number and department name in another table write the following program.
Use the dept table to step through sequentially and bring up the records with the same department from the employee file. Using an IF calculate a new salary based on the job. Update each record on the employee file with the new salary. In addition calculate the total salary for each department and create a new table with the department number, the department name and the salary.
Second problem:Design, develop, and run your own program using multiple cursors.