Reverse a Number

00:52 0 Comments A+ a-

 Write a PLSQL block to display reverse a number.

Program:



declare
num1 int;
num2 int;
rev int;
begin
num1:=143;
rev:=0;
while num1>0
loop
num2:=num1 mod 10;
rev:=num2+(rev*10);
num1:=floor(num1/10);
end loop;
dbms_output.put_line('Reverse number is: '||rev);
end;
/

Output:

Reverse number is: 341