Posted by post on 11/07/06 14:59

Hello,

i have a table and if a record is inserted i will test a numeric value
in this table. If the this value is greather as 1 million, than an
status column should be changed from 'A' to 'B'.

Yes and sorry, this is a newbie question.

On Oracle this work simple:

create trigger myTrigger on tableX
as
begin
if :old.x > 100000 then
:new.y:='B'
end if;
end;


Thanks
Maik

• Next in forum: Re: t-sql turn off a cpu
• Prev in forum: Re: Return dataset in one column
• Thread view: Changing column values on table insert trigger

[Reply to this message]