oracle 设置字段自增

CREATE TABLE T_MCA_MOVERELATION(
MOVE_RELATION_ID NUMBER(11) NOT NULL ENABLE primary KEY,
MOVE_TYPE_ID NUMBER(11) NOT NULL,
SR_NODE_ID NUMBER(11),
SR_NODE_CODE VARCHAR2(20),
SR_NODE_NAME VARCHAR2(400),
SR_AREA_ID NUMBER,
SR_AREA_NAME VARCHAR2(400),
TN_NODE_ID NUMBER(11),
TN_NODE_CODE VARCHAR2(20),
TN_NODE_NAME VARCHAR2(400),
TN_AREA_ID NUMBER,
TN_AREA_NAME VARCHAR2(400)
)

--示例
CREATE SEQUENCE MOVE_RELATION_ID_SEQ
NOMINVALUE
NOMAXVALUE
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;

--示例
CREATE OR REPLACE TRIGGER MOVE_RELATION_ID_TRI --触发器名称，格式：表名_自增的字段名_TRI
BEFORE INSERT ON T_MCA_MOVERELATION
FOR EACH ROW
WHEN (NEW.MOVE_RELATION_ID IS NULL)
BEGIN
SELECT MOVE_RELATION_ID_SEQ.NEXTVAL INTO:NEW.MOVE_RELATION_ID FROM DUAL;
END;