reverse函数功能就是反向排列给定的数组元素
SQL> create or replace function Rev(s string) return varchar2 is
Result varchar2(10000);
v_s string(10000);
begin
for i in 1..length(s)
loop
Result:=Result||substr(s,length(s)-i+1,1);
end loop;
return(Result);
end Rev;
应用举例:
select reverse(sys_connect_by_path
(reverse(rpad(rownum * lv, 2)) || '=' || rownum || '*' || lv ,' ')
)--rpad(rownum * lv, 2))控制长度,保持格式
from (select level lv from dual connect by level < 10)
where lv = 1
connect by lv + 1 = prior lv;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9778796/viewspace-663710/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9778796/viewspace-663710/