--符合规范:
declare
i_l_count number;
i_l_variable1 number;
begin
select count(*) into i_l_count from t_tablename;
if (i_l_count > 0) then
i_l_variable1 := 1;
end if;
end;
declare
i_l_count number;
i_l_variable1 number;
begin
select count(*) into i_l_count from t_tablename;
if (i_l_count > 0) then
i_l_variable1 := 1;
end if;
end;