Scenario-Based Sample SQL Queries
In this article, we will see how to CALCULATE THE NET SALARY Basic HRA and DA Using PLSQL Program. IF DA IS 30% OFF BASIC, HRA IS 10% OF BASIC AND PF IS 7% IF BASIC SALARY IS LESS THAN 8000, PF IS 10% IF BASIC SAL IS BETWEEN 8000 TO 160000. Net Salary Formula … Read more
Area of circle plsql program In this article, we will see how to find Area of circle using plsql program for a given number. In a similar way, you can also find the Area and Perimeter Of Rectangle in PLSQL. What is Circle: A circle closed Aeroplan geometric shape. In specialized terms, a circle is … Read more
To unfold a bit on the other answers how to create table in pl SQL procedure. Yes, you must use dynamic SQL to produce a table or perform any other kind of DDL (data description language) operation in PL/ SQL. There are two commonly used methods to execute DDL from PL/ SQLFirst, “ roll your … Read more
In this article, You will be able to understand how to write a PL/SQL Program to Check Number is Odd or Even. An even number may be a number that will be divided into two equal groups. An odd number must be a number that can’t be divided into two equal groups. Even numbers end … Read more
In this article, we will see how to write PLSQL Program to find Fibonacci Series. As per the portrayal of the Fibonacci series, first, two math are 0 and 1 and each later number is the sum of the precedent two math in the series. Fibonacci series. Following are the places where we can implement … Read more
Find the factorial of a number in PLSQL The factorial of a number in PLSQL is defined as the specified number and it multiplies with the previous numbers till the end without multiplies with zero. Using PLSQL we can write an easy program using PLSQL. Let us see how we can write a program for … Read more
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
Query: Write a PLSQL block using the cursor to print the name salary of all employees working in the Sales department In this blog, we will see PLSQL 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