Bonjour,

I'm as green as can be....and I created a function but could not drop it when
things went south.....

create or replace function available(client_id, property_id)
return number
is
ret number := 0;
begin
begin
select nvl2(c.client_id,1,0)
into ret
from client c, property p
where p.property_id = property
and p.asking_price <= c.max_rent(+)
and c.client_id (+) = client;
exception
when no_data_found then
ret := 0;
end;
return ret;
end;
/

Did you try:

Code:

DROP FUNCTION AVAILABLE;