sql字符串反转

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

在这里，您将获得pl / sql程序以反转数字。

For example:

例如：

Number = 34589

数= 34589

Reverse of number = 98543

倒数= 98543

用于数字反转的PL / SQL程序 (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;/

Output

输出量

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

输入n的值：4578 旧8：n：=＆n; 新8：n：= 4578; 反向是8754

翻译自:

sql字符串反转