create trigger rxx_tri before insert on rxx for each row begin update gis_idd set mapid=(select lpad(路编号||弄编号||号编号,4,'0') from d_lm where 路名=substr(:new.dzxz,...)) where 路名=substr(:new.dzxz,...); end; /
我想应该是这样的。 create trigger rxx_tri before insert on rxx for each row begin update gis_idd set mapid=(select lpad(路编号,4,'0')||lpad(弄编号,4,'0')||lpad(号编号,4,'0') from d_lm where 路名=substr(:new.dzxz,...)) where 路名=substr(:new.dzxz,...); end; /
before insert on rxx
for each row
begin
update gis_idd set mapid=(select lpad(路编号||弄编号||号编号,4,'0') from d_lm where 路名=substr(:new.dzxz,...)) where 路名=substr(:new.dzxz,...);
end;
/
create trigger rxx_tri
before insert on rxx
for each row
begin
update gis_idd set mapid=(select lpad(路编号,4,'0')||lpad(弄编号,4,'0')||lpad(号编号,4,'0') from d_lm where 路名=substr(:new.dzxz,...))
where 路名=substr(:new.dzxz,...);
end;
/