Sum of odd numbers using for loop in pl/SQL. In this article, we will see how to write a PL/SQL program to get the sum of odd numbers using for loop in pl/SQL. Here you can check the query with output. Sum of first odd number = 1 and the Sum of first two odd … Read more
What is SQL Injection Attack? It is one of the most common and SQL dangerous methods hackers can use to attack websites using the SQL injection attack method. We’ll talk about how to execute and mitigate web application attacks such as SQL injection, command injection, and cross-site scripting. SQL is used to operate queries and … Read more
Why Do Relational Databases Use Primary Keys and Foreign Keys? The name says relational database. The database relationships can be defined with respect to key columns. These key columns can be identified based on cardinality. This is the reason why Relational Databases Use Primary Keys and Foreign Keys. Let us take an example of the … Read more
MySQL versus PostgreSQL versus SQL Server and TheTop 7 Features of SQL Database. Hey everyone in this article we’ll be discussing the three most popular relational databases MySQL vs PostgreSQL vs SQL server and the Top 7 Features of SQL Database. Here we share our delivery insights in the tech industry. MySQL is a definite … 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
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
Find the factorial of a number in PLSQL This can be defined as the specified number and it multiplies with the previous numbers till the end without multiplies with zero. Using the PLSQL we can write an easy program to find the factorial of a number in PLSQL. Let us see how we can write … 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