SQL语句的REVERSE函数,关键字用法
1.函数。
select reverse(123456) from dual;
select reverse('123456') from dual;
2.关键字。
declare
v number;
c number;
begin
v:=100;
for c in reverse 1 .. v loop
dbms_output.put_line(c);
end loop;
end;
1.函数。
select reverse(123456) from dual;
select reverse('123456') from dual;
2.关键字。
declare
v number;
c number;
begin
v:=100;
for c in reverse 1 .. v loop
dbms_output.put_line(c);
end loop;
end;