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
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 ; |
Output:
before num1 = 1000 num2 = 2000 after num1 = 2000 num2 = 1000
Contact Us