oracle 中使用触发器自动生成UUID
create or replace trigger tri_test before insert on test for each row declare begin if :new.uuid is null then :new.uuid:=sys_guid(); end if; end tri_test;
create or replace trigger tri_test before insert on test for each row declare begin if :new.uuid is null then :new.uuid:=sys_guid(); end if; end tri_test;