create or replace trigger citycode_trigger(触发器名) before|after insert (操作)on citycode (表名)
for each row
begin
select (to_char(sysdate,'yyyymmddhhmiss')||lpad(seq1.nextval,6,'0'))
into :new.cityid(生成的id列)
from dual;
end;
for each row
begin
select (to_char(sysdate,'yyyymmddhhmiss')||lpad(seq1.nextval,6,'0'))
into :new.cityid(生成的id列)
from dual;
end;