Hi,
a compile should issue a warning, if not all selected columns of a select cursor are used subsequently.
...
cursor c1 is
select col1,col2 from table;
x varchar2(20) := '';
begin
for crec in c1 loop
x:= x||crec.col1;
end loop;
dbms_output.put_line(x);
end;
Assumed Hint: "Columns selected but not used in cursor c1: col2."
a compile should issue a warning, if not all selected columns of a select cursor are used subsequently.
...
cursor c1 is
select col1,col2 from table;
x varchar2(20) := '';
begin
for crec in c1 loop
x:= x||crec.col1;
end loop;
dbms_output.put_line(x);
end;
Assumed Hint: "Columns selected but not used in cursor c1: col2."
