declare aa varchar2(20); amount integer; offset number; str varchar(20); strNum varchar(20); begin strNum:=to_char(&num); offset:=length(strNum); amount:=1; for i in reverse 1..offset loop dbms_lob.read(strNum,amount,i,aa); str:=str||aa; dbms_output.put_line(i); end loop; dbms_output.put_line(str); dbms_output.put_line(str||'adfadf'||offset); end; /
aa varchar2(20);
amount integer;
offset number;
str varchar(20);
strNum varchar(20);
begin
strNum:=to_char(&num);
offset:=length(strNum);
amount:=1;
for i in reverse 1..offset
loop
dbms_lob.read(strNum,amount,i,aa);
str:=str||aa;
dbms_output.put_line(i);
end loop;
dbms_output.put_line(str);
dbms_output.put_line(str||'adfadf'||offset);
end;
/