# Category Archives: PL/SQL

## 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 is… 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 8

## 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 5… 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 for… Read More »

## PL/SQL Transactions

A PL/SQL transaction is a collection of operations or instructions which is executed as a whole atomic unit. A transaction can access and manipulate various data items. In a multi-user environment, every user is working with his own transaction independence, keeping the database in an inconsistent format. There are few properties which every stable database… Read More »

## PL/SQL Exception Handling

An exception is a condition which executes when an error occurs during execution of a PL/SQL program. PL/SQL provides a feature that lets the programmers to handle these exceptions in the exception block in a PL/SQL program. Exception block contains the methods (defined by the programmer) which can provide a particular action that needs to… Read More »