触发器，新增本条数据后再修改本条数据的一个字段

create or replace trigger modify_test
before INSERT ON ia_iabill_b 
for each row
 begin
    SELECT a.name
      INTO :new.新增本条数据的一个字段
      from 
          ia_iabill iabill
          left join (
          select distinct flow.pk_org,flow.cmaterialvid,defdoc.name from ic_flow flow 
          left join bd_defdoc defdoc on flow.vfree1=defdoc.pk_defdoc) a
          on iabill.cstockorgvid = a.pk_org 
      where a.CMATERIALVID=:new.cinventoryid and iabill.cbillid=:new.cbillid and rownum<=1;
  exception when no_data_found then
  :new.vbdef1:='~';（若获取的数据为空时，自动输入~）
END modify_test;