oracle update equivelent

I used this trigger in interbase but am now converting everything to oracle 8i Win NT. I had a trigger which updates a field in the customer table (plan_id) which equals the customer_id of the current mobile row. The trigger is:

create trigger mobile_binary for mobile after insert as
begin
  update customer set plan_id = plan_id + 1 where mobile.customer_id = customer_id;
end

How do I implement this in oracle.

Thanks in advance Received on Thu Oct 14 1999 - 02:36:57 CDT