Re: oracle update equivelent

create or replace trigger mobile_binary on mobile after insert for each row begin
update customer
set plan_id = plan_id + 1
where customer_id = :new.customer_id;
end;
/

Hth,

--
Sybrand Bakker, Oracle DBA
Sebastian Degenaar <degenaar_at_adlink.com.au> wrote in message news:38058819.23CA472B_at_adlink.com.au...
> 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 - 13:55:39 CDT