Dear Experts,
Currently I am doing as below to get the first row of a cursor. Please guide me if this will break after sometime or not.
declare
cursor c_get_info is
select person_id from per_all_people_f
order by person_id desc;
l_person_id number; ---Not a cursor Row type variable
begin
open c_get_info;
fetch c_get_info into l_person_id;
close c_get_info;
dbms_output.put_line('Person_id:'||l_person_id);
end;