oracle 没有主键的表，添加主键并且给主键赋值

1. 添加主键（不标记主键、可以为空）

ALTER TABLE "LSJ_SERVER"."BASE_DRIVER_TRUCK" 
ADD ("ID" NUMBER);

COMMENT ON COLUMN "LSJ_SERVER"."BASE_DRIVER_TRUCK"."ID" IS '主键'

2. 更新ID的值

UPDATE BASE_DRIVER_TRUCK SET ID = rownum;

3. 设置主键

ALTER TABLE "LSJ_SERVER"."BASE_DRIVER_TRUCK" 
MODIFY ("ID"  NOT NULL);

ALTER TABLE "LSJ_SERVER"."BASE_DRIVER_TRUCK" ADD PRIMARY KEY ("ID");

4. 设置自增主键的值

创建
START WITH ：开始的值 取决 更新ID的值 后的最大的ID的值+n即可

SELECT MAX(ID) FROM BASE_DRIVER_TRUCK 

INCREMENT ： 增量

 CREATE SEQUENCE my_sequence
START WITH 100000
INCREMENT BY 1
NOCACHE;

删除

DROP SEQUENCE my_sequence;

5. 添加触发器

CREATE OR REPLACE TRIGGER BASE_DRIVER_TRUCK_trigger_ID
BEFORE INSERT ON BASE_DRIVER_TRUCK
FOR EACH ROW
BEGIN
    SELECT my_sequence.NEXTVAL
    INTO :new.ID
    FROM dual;
END;

添加数据，完成。