select sum (pret*cantitate)into p_val
from comenzi t join rand_comenzi r on
t.nr_comanda = r.nr_comanda where id_client =p_client_id
and extract (year from t.data)=p_year;
else
select sum(pret*cantitate)into p_val
from comenzi t join rand_comenzi r on
t.nr_comanda=r.nr_comanda where id_client=p_client_id;
end if;
return nvl(p_val,0);
end;
/