In Progress

week 10 - Oracle and sql assignment

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.

Skills: Oracle, SQL

See more: oracle sql week assignment, sql to oracle, sql oracle pl sql, pl sql files, pl sql and oracle, pl sql and, oracle sql pl, if oracle pl sql, calculate and write, pl sql oracle, oracle sql with, write assignment, SQL PL SQL , pl\sql, PL/SQL, PL-SQL, oracle:pl, oracle pl/sql, oracle pl, assignment write, using oracle, cursors, salary salary oracle sql, per assignment, employee time sql

About the Employer:
( 23 reviews ) poop, United States

Project ID: #4407358

Awarded to:


Once again lets start.....

$50 USD in 6 days
(6 Reviews)

4 freelancers are bidding on average $54 for this job


I am interested in your project. Please let's me help you

$69 USD in 2 days
(11 Reviews)

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

$53 USD in 3 days
(5 Reviews)

Hi I have more than nine years experience in oracle Database Administration. Please see PM. thanks

$45 USD in 3 days
(1 Review)