The first and last record in a cursor for loop

[LKBrwn_DBA]

Try this:

for rec in (select COLUMN_NAME, COLUMN_ID
from user_tab_columns
where table_name=upper('&1')
order by column_id)
loop
if rec.column_id = 1 then
----------------
else
----------------
end if;

end loop;