Oracle modifies the eligible records according to several conditions.
Declare i number; temp_sum number; temp_hfmpcode temptable.pubname%type;-- temptable.pubname%type refers to the type of pubname field of the temptable table temp_fullname temptable.pubcode%type;begin select count (*) into temp_sum from temptable b; i: = 1; while I