I want to create a pl/sql procedure that perform summary function on som feild in the database then add to a variable
something like

select sum(salary) into sal from employees where emp_no = :empno;
sal := sal +var;

salary is database field
sal , var are variables

the problem is when the salary field doesnt contain data
so if there any way to check if the select statement doesn't return any
result and replace its value with 0 like nvl function

thanx

تم تعديل 3 أغسطس 200619 سنة بواسطة ahmedmax

you can use

where sal<>null

thanks