--创建表
create table test
(
id number primary key,
name varchar2 not null
);
--创建序列
create sequence test_seq
start with 1 increment by 1;
--创建触发器
create or replace trigger tri_test_zz
before insert on test
for each row
begin
select test_seq.nextval into :new.id from dual;
end;
oracle自增列的问题
最新推荐文章于 2024-09-13 17:04:58 发布