create or replace trigger tg_insertUsr
before insert on LXX.xx_usr for each row when(new.usr_id is null)
begin
select SEQ_USRID.Nextval into:new.usr_id from LXX.XX_USR;
before insert on LXX.xx_usr for each row when(new.usr_id is null)
begin
select SEQ_USRID.Nextval into:new.usr_id from LXX.XX_USR;
end;
以上是参照例子建的一个触发器。into:后面不能有空格。有空格执行报错。