Hi,
I need to check if atleast one record present in table before processing rest of the statements in my PL/SQL procedure. Is there an efficient way to achieve that considering that the table is having huge number of records like 10k
I am using like below
select count(*) into flag
from T1 where ID = input_id;
if flag > 0
then perform operations
else
do nothing