Trigger那有点毛病.
create trigger test before
insert on emp for each row when (new.id is null)
begin
--new.dept代表插入时的dept.---postion
select new.dept||new.position||sequence.nextval into :new.id from dual;
end;
1.建立通用主键
2.在DB里建个sequence.
3.写个Trigger.
create trigger test before
insert on emp for each row when (new.id is null)
begin
select (select dept||positon from emp)||sequence.nextval into :new.id from dual;
end;
你试下,看行不