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 declare a number; b number; temp number; begin a:=5; b:=10; dbms_output.put_line(‘before swapping:’); dbms_output.put_line(‘a=’||a||’ b=’||b); temp:=a; a:=b; b:=temp; dbms_output.put_line(‘after swapping:’); dbms_output.put_line(‘a=’||a||’ b=’||b); end; / Output before swapping: a=5 b=10 after swapping: a=10 b=5 Method 2: Without …

PL/SQL Program to Swap two Numbers Read More »

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 declare n number; m number; rev number:=0; r number; begin n:=12321; m:=n; while n>0 loop r:=mod(n,10); rev:=(rev*10)+r; n:=trunc(n/10); …

Pl/SQL Program for Palindrome Number Read More »