sequence 作为序列插入值不是第一个

CREATE SEQUENCE seq_test 　　　　

INCREMENT BY 1 　　　　

START WITH 1 ;

创建表时 或执行  ALTER SYSTEM SET deferred_segment_creation=FALSE;

CREATE TABLE tbl_test( test_id NUMBER PRIMARY KEY,     test_name VARCHAR2(20) ) 

SEGMENT CREATION IMMEDIATE;

 

insert into tbl_test values(seq_test.nextval,'abc')

select * from tbl_test

转载于:https://www.cnblogs.com/tianmingt/p/4055967.html