ORALCE 创建自增长列

0、添加字段
ALTER TABLE T_CUST ADD ID number
1、创建表
CREATE TABLE T_CUST(
CUST_ID INT NOT NULL,
CUST_NAME VARCHAR2(20) NOT NULL,
CONSTRAINT PK_T_CUST PRIMARY KEY (CUST_ID)
);
2、创建序列
CREATE SEQUENCE S_CUST_ID
MINVALUE 1
MAXVALUE 10000000
START WITH 1
INCREMENT BY 1
NOCACHE;

3、试试序列是否起作用
INSERT INTO T_CUST(CUST_ID, CUST_NAME) VALUES(S_CUST_ID.NEXTVAL, '测试_1');
INSERT INTO T_CUST(CUST_ID, CUST_NAME) VALUES(S_CUST_ID.NEXTVAL, '测试_2');
INSERT INTO T_CUST(CUST_ID, CUST_NAME) VALUES(S_CUST_ID.NEXTVAL, '测试_2');