PLSQL Program to find Fibonacci Series

Fibonacci Numbers are the sequence of numbers starting with zero and one. In this article, we will see how to write a PLSQL Program to find the Fibonacci series. For each of the following is sum of the previous two. 0,1,1,2,3,5,8,13,21,34,55… The Fibonacci Series Formula is given below With the selected values F0=0 and F1 … Read more

Area and Perimeter Of Rectangle in PLSQL

Prerequisite – PLSQL Introduction A PLSQL code is a groups of commands which are arranged within a block and block is a group of related declarations or statements. Now, let us see a practical example of the area and perimeter of rectangle. In declare part, we declare the list of variables and between begin and … Read more

PL/SQL block using the cursor to print all employees working in the Sales department

Query: Write a PL/SQL block using the cursor to print the name salary of all employees working in the Sales department In this blog, we will see PL/SQL Block using the cursor to print the name salary of all employees working in the sales department. Consider the employee table has the following columns based on … Read more