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

السلام عليكم و رحمة الله و بركاتة
يا ahmedmax انت حليتها بنفسك
جرب
select Nvl(sum(salary), 0) into sal from employees where emp_no = :empno;
sal := sal +var;
و لو ما اشتغلتش لقدر الله قولى نجرب حاجة تانى

جرب الحل ده
select sum(salary) into sal from employees where emp_no = :empno;
sal := nvl(sal,0) +nvl(var,0);

hi ashraffarouk

I already tried
select Nvl(sum(salary), 0)
but it failed because the table is empty
I want a way to check if the table already have tuples or not

thanx in advance

Hi Rady

It works

You are genius

thanx