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 Using Temporary Variable

declare
    a number;
    b number;

begin
    a:=5;
    b:=10;
    
    dbms_output.put_line('before swapping:');
    dbms_output.put_line('a='||a||' b='||b);
    
    a:=a+b;
    b:=a-b;
    a:=a-b;
    
    dbms_output.put_line('after swapping:');
    dbms_output.put_line('a='||a||' b='||b);
    
end;
/

The post PL/SQL Program to Swap two Numbers appeared first on The Crazy Programmer.

from The Crazy Programmer http://www.thecrazyprogrammer.com/2017/08/plsql-program-swap-two-numbers.html