Swap two numbers in PL/SQL

In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements.
In declare part, we declare variables and between begin and end part, we perform the operations.

Basic structure of pl/sql block

declare
-- declare all the variables

begin  -- for start block
-- make a program here

end -- for end block

You have given two numbers num1 and num2 the your task is to swap the value of given numbers.



Examples:

Input : num1  = 1000 num2 = 2000
Output : num1  = 2000 num2 = 1000

Input : num1  = 40 num2 = 20
Output : num1  = 20 num2 = 40
filter_none

edit
close

play_arrow

link
brightness_4
code

declare
  
-- declare variable num1, num2 
-- and temp of datatype number
    num1 number;
    num2 number;
    temp number;
  
   
begin
    num1:=1000;
    num2:=2000;
      
    -- print result before swapping
    dbms_output.put_line('before');
    dbms_output.put_line('num1 = '|| num1 ||' num2 = '|| num2);
      
    -- swapping of numbers num1 and num2
    temp := num1;
    num1 := num2;
    num2 := temp;
      
   -- print result after swapping
    dbms_output.put_line('after');
    dbms_output.put_line('num1 = '|| num1 ||' num2 = '|| num2);
      
end;

chevron_right


Output:

before
num1  = 1000 num2 = 2000
after
num1  = 2000 num2 = 1000


My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.