现在有一张表 o_canvass 主键是varchar(32),现在要建一个触发器,使每次插入一条记录都自动插入主键,主键是guid/uuid
触发器代码如下:
create or replace trigger tigger_o_canvass
before insert on o_canvass
for each row
declare
begin
--select sys_guid() from dual 在oracle中获取guid
select sys_guid() into :New.ID from dual;
--select to_char(sysdate,'YYYY-MM') from dual oracle获取当前日期
--select to_char(sysdate,'YYYY-MM') into :New.YEAR_MONTH from dual;
end tigger_o_canvass;
p>下面是生成的
9206FF1596484104A39BA7623B84AD04