Here you will get pl/sql program to swap two numbers with and without using temporary variable.
Method 1: Using Temporary Variable
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
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; / |
