PL/SQL Program for Reverse of a Number

Here you will get pl/sql program for reverse of a number.

For example:

Number = 34589

Reverse of number = 98543

PL/SQL Program for Reverse of a Number

declare
	n number;
	i number;
	rev number:=0;
	r number;

begin
	n:=&n;
	
	while n>0
	loop
		r:=mod(n,10);
		rev:=(rev*10)+r;
		n:=trunc(n/10);
	end loop;

	dbms_output.put_line('reverse is '||rev);

end;
/

declare

n number;

i number;

rev number:=0;

r number;

begin

n:=&n;

while n>0

loop

r:=mod(n,10);

rev:=(rev*10)+r;

n:=trunc(n/10);

end loop;

dbms_output.put_line('reverse is '||rev);

end;

Output

Enter value for n: 4578
old 8: n:=&n;
new 8: n:=4578;
reverse is 8754

PL/SQL Program for Reverse of a Number

Related Posts

Leave a Comment Cancel Reply