How to iterate over all attributes of %rowtype variable
405435Dec 11 2003 — edited Dec 14 2003I have the following code:
declare
cursor c is select * from table;
r c%rowtype;
begin
for r in c loop
process(r.attr1);
process(r.attr2);
process(r.attr3);
process(r.attr4);
process(r.attr5);
-- ...
end loop;
end;
Since the members of r may change (or there may be lot of them), I would need to iterate over them. Is this possible?