Question: Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID 901 Abdullah Bisha 10-Feb-1998 10000 101 902 Dafer Abha 01-Oct-1999 5000 102

Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID

 

Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID 901 Abdullah Bisha 10-Feb-1998 10000 101 902 Dafer Abha 01-Oct-1999 5000 102 903 Saad Alaya 10-Dec-1994 8000 101 904 Saeed Riyadh 10-Dec-1990 4000 103 DeptID Dname 001 Management 002 Production 003 Supply Department Table 1. Calculate the net salary if DA is 15% of basic,HRA is 10% of basic and PF 10% if basic salary is less than 6000 pf is 10% if basic salary between 8000 to 160000. 2. Write a procedure that display department id for a particular person. 3. Write a procedure to display the total number of person of a department 101. 4. Write a function that returns the total number of employee of a particular department. Accept department ID as input parameter. 5. Write a function to find the maximum Salary.

Step by Step Solution

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

declare ename varchar 215 basic number da ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!