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
Article Tags :