Solved-Lab Exercise 06 (PL/SQL) -Solution

Description

1. Write a PL/SQL code that takes two inputs from user, add them and store the sum in new variable and show the output.

2. Write a PL/SQL code that takes two inputs, lower boundary and upper boundary, then print the sum of all the numbers between the boundaries INCLUSIVE.

3. Write a PL/SQL code to retrieve the employee name, hire date, and the department name in which he works, whose number is input by the user.

4. Write a PL/SQL code to check whether the given number is palindrome or not.

5. Write a PL/SQL code that takes all the required inputs from the user for the Employee table and then insert it into the Employee and Department table in the database.

6. Write a PL/SQL code to find the first employee who has a salary over $2500 and is higher in the chain of command than employee 7499. Note: For chain, use of LOOP is necessary.

7. Write a PL/SQL code to print the sum of first 100 numbers.

Views:

8. Create a view, that stores information of only those employees who belongs to Accounts department.

Cursors:

9. Write a PL/SQL code to print out the employee information who earns more than 2000 salary.

10. Write a PL/SQL program displaying top 10 employee details

Procedures:

11. To Write a pl/sql program for creating a procedure for calculating sum of two numbers. Execute it as well.