本文详细介绍了如何使用PL/SQL创建短信主键自增序列，并通过触发器实现每插入一条记录时自动生成唯一的UUID。
/******* 创建短信主键自增 *************/
create sequence msm_sequence
minvalue 1
nomaxvalue
start with 1
increment by 1
nocycle
nocache;
CREATE OR REPLACE TRIGGER tr_msm_sequence
BEFORE
insert on NET_SMS_EXCHANG
for each row
begin
select msm_sequence.nextval into :NEW.SMS_EXCHANG_UUID from dual;
end;
create sequence msm_sequence
minvalue 1
nomaxvalue
start with 1
increment by 1
nocycle
nocache;
CREATE OR REPLACE TRIGGER tr_msm_sequence
BEFORE
insert on NET_SMS_EXCHANG
for each row
begin
select msm_sequence.nextval into :NEW.SMS_EXCHANG_UUID from dual;
end;
扫一扫
187
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
