if exist in pl/sql

[ahmedmax]

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 أغسطس 2006 بواسطة ahmedmax

[sms423]

you can use

where sal<>null

[ahmedmax]

thanks