jdbc是支持创建触发器的,只是有个比较变态的要求,那就是:
需要将内容全部写在同一行,不能有回车换行,否则会报错
这样写是会报错的:
create or replace trigger A
before insert on T
for each row
begin
if(:new.F_ID is null) then
SELECT S.nextval into :new.F_ID from dual;
end if;
end;
create or replace trigger A
before insert on T
for each row
begin if(:new.F_ID is null) then SELECT S.nextval into :new.F_ID from dual; end if; end;