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
تم التعديل بواسطة ahmedmax, 03 August 2006 - 01:43 PM.