我已经创建了一个带有列 S_ROLL NUMBER(3) NOT NULL
的表格,现在我想将该列变为自增列。
我使用了以下命令:
alter table students
modify
(
S_ROLL NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY
);
然后我遇到了这个错误。
S_ROLL NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY
*
ERROR at line 4:
ORA-30673: column to be modified is not an identity column