Lab Exercise 06 (PL/SQL) Solution

$30.00

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.

  1. 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.

  1. 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.

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

  1. 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.

  1. 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.

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

Views:

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

Cursors:

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

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

Procedures:

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