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 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
declare ename varchar 215 basic number da ... View full answer
Get step-by-step solutions from verified subject matter experts
