当插入时,自动生成GUID作为主键,代码如下:
CREATE OR REPLACE TRIGGER tr_company
before insert on company
for each row
begin
select sys_guid() into :new.COMPANYID from dual;
end;
before insert on company
for each row
begin
select sys_guid() into :new.COMPANYID from dual;
end;