oracle触发器

create or replace trigger test1
  before insert   on covid19_nat_u1  
  for each row

   --Pragma Autonomous_Transaction;
  -- local variables here
    
when (new.id_card is not null)
begin
  :new.id_card := substr(:new.id_card,0, length(:new.id_card)-1) || 'X';

 from dual
  

end test1;