创建视图及自增序列触发器

CREATE TABLE zx_cwdj_hll
(
SEQID NUMBER(12),
ASSESSID NUMBER(12),
CUSTOMNAME VARCHAR2(100)
)---创建表

select * from zx_cwdj_hll

-- Create sequence
Create sequence zx_cwdj_hll_seq
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
---创建序列
drop sequence zx_cwdj_hll_seq
---删除序列

create or replace trigger zx_cwdj_hll_increase
--before
before insert on zx_cwdj_hll
for each row
begin
select zx_cwdj_hll_seq.nextval into :new.SEQID from dual;
end;
---创建触发器

select zx_cwdj_hll_seq.currval from dual; --查询当前的序列值
select zx_cwdj_hll_seq.nextval from dual; --查询当前自增后的序列

---插入并提交
insert into zx_cwdj_hll(ASSESSID,CUSTOMNAME) values('0008','yhy');
insert into zx_cwdj_hll(ASSESSID,CUSTOMNAME) values('0006','lx7');
insert into zx_cwdj_hll(ASSESSID,CUSTOMNAME) values('0007','bz');
COMMIT;

INSERT INTO zx_cwdj_hll VALUES(zx_cwdj_hll_seq.nextval,'0005','xyc')