1
2
3
4
5
6
7
8
9
10
create or replace trigger _trigger_name
before insert or update on TABLE_NAME
for each row
declare
-- local variables here
begin
:new.ID := SYS_GUID;
end _trigger_name;

-- 插入或更新数据后修改ID