grant create session,resource to xcl
create table testuser(id int primary key,name varchar2(20),age int )
CREATE SEQUENCE
testuser_Sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
CREATE TRIGGER
testuser BEFORE
insert ON testuser FOR EACH ROW
begin
select testuser_Sequence.nextval into:New.id from dual;
end;
select * from testuser
create table testuser(id int primary key,name varchar2(20),age int )
CREATE SEQUENCE
testuser_Sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
CREATE TRIGGER
testuser BEFORE
insert ON testuser FOR EACH ROW
begin
select testuser_Sequence.nextval into:New.id from dual;
end;
select * from testuser