Vellore Institute of Technology

• DBMS CSE2004

• PL/SQL 1. Write a PL/SQL block to accept an empno and display the salary of the person. 2. Write a PL/SQL program to delete one record in the employee table. 3. Write a PL/SQL program to delete employee details who are having age >60. 4. Write a PL/SQL block to find the area of the circle and perimeter. 5. Write a PL/SQL block to display employees must make a minimum salary of $1,000. 6. Write a PL/SQL to delete a record whose basic salary is <2000 from the Emp table. Using control Statements 1. Write a PL/SQL code to check if a given number is even or odd. 2. Write a PL/SQL block to find the greatest of three numbers. 3. Write a PL/SQL code to print the student’s grade accepting their marks in three subjects(hint use: case selector….) 4. Write a PL/SQL block to satisfy the following conditions For the employees of “Production” department If he is a manager give a hike of 30% in the salary, 20% for the programmer, 10% for laymen. Assume the following table for the above implementation. Empname, Eno, Address, Designation, Department, Basic salary, Extra hour, Hra, Da, Bonus and Net pay. Write a PL/SQL program to implement the following condition