怎么在一个已经建好的表里面实现oracle 10g 修改主键为自增字段???小小菜鸟,求步骤!
oracle没有自增的
要建个序列源基和建个触发器实橡型现
--建序列
CREATE SEQUENCE "CLIENT_SQ";
--建触发器
CREATE OR REPLACE TRIGGER "CLIENT_TR"
BEFORE INSERT ON "CLIENT"雹如谨
FOR EACH ROW
WHEN (new."ID" IS NULL)
BEGIN
SELECT "CLIENT_SQ".nextval
INTO :new."ID" FROM dual;
END;
/