Hi All
I have a PL/SQL Procedure in which following statement is there
Select sum(amount) from deal where acntid=9834;
I want to do some processing if no data is found for the query.The mount field can be null also.How this can be done.i.e how can I check whether NO_DATA_FOUND is being returned from the query i.e not a single row exists for the condition in PL/SQL.