CREATE SEQUENCE BOOTTIME_sequence INCREMENT BY 1 START WITH 1 NOMAXVALUE nocycle nocache 注释: BOOTTIME_sequence: 自增序列名称,BOOTTIME为表明 INCREMENT BY 1 : 每次加几个 START WITH 1 : 从1开始计数 NOMAXVALUE: 不设置最大值 NOCYCLE : 一直累加,不循环 一旦定义了emp_sequence(此处为 BOOTTIME_sequence ),你就可以用CURRVAL,NEXTVAL. CURRVAL=返回 sequence的当前值。 NEXTVAL=增加sequence的值,然后返回 sequence 值。
insert into BOOTTIME( ID, EQUIPMENT_ID, STARTTIME, STOPTTIME, TOTALTIME, BDATE) values( BOOTTIME_sequence.nextval, sysdate, (null), '2017-03-21' )
CREATE SEQUENCE BOOTTIME_sequence INCREMENT BY 1 START WITH 1 NOMAXVALUE nocycle nocache 注释: 一旦定义了emp_sequence(此处为 BOOTTIME_sequence ),你就可以用CURRVAL,NEXTVAL. CURRVAL=返回 sequence的当前值。 NEXTVAL=增加sequence的值,然后返回 sequence 值。
create or replace trigger BOOTTIME_trigger before insert on BOOTTIME for each row begin select BOOTTIME_sequence.nextval into :new.ID from dual; end;
insert into BOOTTIME( EQUIPMENT_ID, STARTTIME, TOTALTIME,BDATE) values( 59635, (null), '2017-03-21' )
如对本文有疑问, 点击进行留言回复!!
每日一记:Oracle升级2020年4月份的数据库补丁Database Patch Set Update : 11.2.0.4.200414 (30670774)
Oracle 19.3 dataguard for Redhat 7.6
网友评论