السلام عليكم و رحمة الله وبركاته
إخوتي الأعضاء ........
ارجو مساعدتي في حل هذا البرنامج
وشكرا جزيلا لكم
الواجب كالتالي:

Write a complete PL/SQL program that's manage a new year budgets as follow:

1) increase all salaries with 30% of employee curent salary( this is a Royal Grant)

2) The annual increase for each employee depending on it's job (note that if the employee reaches the maximum salary of its job then no the annual increase for him )

3) There is a new Allowance for all employees in Sales department because of the work pressure it is equal to 15% of employee current salary.

4) For each of the above budget jobs (1,2.3) the processing should be either complete for all employees under condition or you should not confirm any changes for that job so you can process it later separately.

5) Print a report of your changes in the salary order by salary list pervious salary and new salary for each employee and a massage note one or more changes that perform for each employee ('30% Royal Grant ','Annual increase = 500', '15% pressure Allowance') .

6) Print another report to find the total number of salaries for each department

منتديات مدرسة المشاغبين - تطوير و صيانة المنتديات vBulletin