oracle 创建自增长列

1.建表

CREATE TABLE tb_device (
    id number (10) NOT NULL PRIMARY KEY,
    device_id number (10),
    zhuan_su number (10, 2) NOT NULL,
    wen_du number (10, 2) NOT NULL
);

2.创建序列tb_device_autoinc_seq:
CREATE sequence tb_device_autoinc_seq minvalue 1 MAXVALUE 99999999 START WITH 1 increment BY 1 nocycle nocache ORDER;

3.  创建触发器tb_device_autoinc_tg：

CREATE
OR REPLACE TRIGGER tb_device_autoinc_tg BEFORE INSERT ON tb_device FOR EACH ROW
BEGIN
    SELECT
        tb_device_autoinc_seq.nextval INTO : new.id
    FROM
        DUAL;
END tb_device_autoinc_tg;