TRIGGER

[Nsan]

Hi,

I need to create a trigger that will replace a value that has been inserted. If a negative number is inserted into a record how to change that value to a positive value.

create or replace trigger num_val
after insert of n_app on emp
begin
If n_app = ( a negative number)

 

[Mockenrue]

Assuming your column is named n_app:

create or replace trigger num_val
after insert
on <TABLE NAME>
for each row
when new.n_app < 0
declare
begin
:new.n_app := absnew.n_app);
end;