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.
Bu iş için 4 freelancer ortalamada $54 teklif veriyor
I am interested in your project. Please let's me help you
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
Hi I have more than nine years experience in oracle Database Administration. Please see PM. thanks