create TRIGGER trigger_zdyfzxxInsert
before insert on B_SPJK_ZDYSPFZXX
for each row
declare
next_id number;
begin
select REGEXP_REPLACE(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),':|-|\s','') into next_id from dual;
:new.fzbh :=next_id;
end;