create or replace trigger trg_name
before insert on t
for each row
begin
  begin
    :new.field2 := to_number(:new.field1);
  exception
    when value_error then
      null;
  end;
end;
/