cursor

declare
u varchar(25);
p transactionlog_info.phyfileid%type;
cursor curs is select t.userid,t.phyfileid from transactionlog_info t ;--where t.phyfileid='1wc847719bb6dc9f1061804ad787a1b26a';
cursor cures is select * from config_info t ;
begin

open curs;
loop
fetch curs into u,p;
exit when curs%notfound;
dbms_output.put_line(u ||' '||p);
end loop;

close curs;

 

for c in cures loop
dbms_output.put_line(c.key ||' ' ||c.value || ''|| c.description);
end loop;
dbms_output.put_line('ddd');
end;