These scripts will create two tables (two versions of the first one):
Then write the PL/SQL program to read the files using cursors and write out the total hours worked by each employee. Then write a modification to the program that takes salaried workers and divides their salary by 52 and display and take hourly workers and multiply the hours they worked by the pay per hour. Then continuing with modifications, calculate hourly works pay if they make overtime. You should use a base of 40 hours and pay time and a half.
I have attached the scripts that are needed for this.
4 freelancers are bidding on average $54 for this job
Hi I have over 10 years of experience with Oracle and PL/SQL and will create the program in a quick time. Please accept the proposal and I will start right away. Thanks Gopisoft Private Limited