Category Archives: PL/SQL

PL/SQL Online Compiler – Run Oracle PL/SQL Programs Online

In this tutorial you will learn about pl/sql online compiler that will let you run pl/sql programs online. Few days back I was writing plsql programs to share on this blog. There was no compiler installed on my system to test these programs. So I thought to run them quickly using online compiler. I found… Read More »

PL/SQL Program for Armstrong Number

Here you will get pl/sql program for armstrong number. A number is said to be an armstrong number if sum of its digits raised to the power n is equal to number itself, where n is total digits in number. For example 407 is armstrong number as 43 + 03 + 73 = 64 + 0 + 343… Read More »

PL/SQL Program to Swap two Numbers

Here you will get pl/sql program to swap two numbers with and without using temporary variable. Method 1: Using Temporary Variable

Output before swapping: a=5 b=10 after swapping: a=10 b=5 Method 2: Without Using Temporary Variable

Pl/SQL Program for Palindrome Number

Here you will get pl/sql program for palindrome number. A number is called palindrome number if its reverse is equal to itself. For example 12321 is palindrome while 123 is not palindrome. Pl/SQL Program for Palindrome Number

Output number is palindrome Comment below if you have any queries regarding above palindrome program in pl… Read More »

Difference between SQL and PL/SQL

Here you will learn about difference between SQL and PL/SQL. SQL and PL/SQL are two popular database technologies. These two topics are very frequently asked in database interviews. In this article I have shared the key differences between these two technologies. Also Read: PL/SQL Interview Questions and Answers Image Source Difference between SQL and PL/SQL S.… Read More »

PL/SQL Program to Reverse a String

Here you will get pl/sql program to reverse a string. The substr() function returns a part of string. It has following syntax. substr(string, position, length); We will use this function to extract character by character from string in reverse order and concatenate it previous extracted character. || is used to concatenate string. In this way string… Read More »

PL/SQL Program to Check Number is Odd or Even

Here you will get pl/sql program to check number is odd or even. A number is even if it is completely divisible by 2 otherwise it is odd.   PL/SQL Program to Check Number is Odd or Even

  Output Enter value for n: 7 old   2:        n number:=&n; new   2:        n number:=7; number… Read More »

PL/SQL Program for Fibonacci Series

Here you will get pl/sql program for fibonacci series. It is a series in which next number is the sum of previous two numbers.   PL/SQL Program for Fibonacci Series

  Output Enter value for n: 6 old 5: n number:=&n; new 5: n number:=6; Fibonacci series is: 0 1 1 2 3 5… Read More »

PL/SQL Program for Reverse of a Number

Here you will get pl/sql program for reverse of a number. For example: Number = 34589 Reverse of number = 98543   PL/SQL Program for Reverse of a Number

  Output Enter value for n: 4578 old 8: n:=&n; new 8: n:=4578; reverse is 8754

PL/SQL Program to Print Table of a Number

Here you will get pl/sql program to print table of a given number. You can ask your queries in comment section.

  Output Enter value for n: 5 old 6: n:=&n; new 6: n:=5; 5 x 1 = 5 5 x 2 = 10 5 x 3 = 15 5 x 4 = 20… Read More »

PL/SQL Program to Find Factorial of a Number

Here you will get pl/sql program to find factorial of a number. We can calculate factorial of a number by multiplying it with all the numbers below it. For example factorial of 5 = 5 x 4 x 3 x 2 x 1 = 120.   PL/SQL Program to Find Factorial of a Number

Read More »

PL/SQL Program for Prime Number

Here you will get a pl/sql program for prime number. A number is a prime number if it is divisible by 1 or itself. For example 2, 3, 5, 7, etc are prime numbers. While numbers like 4, 6, 8, etc are not prime.   PL/SQL Program for Prime Number

  Output Enter value… Read More »