Oracle在给表中字段添加GENERATED BY DEFAULT AS IDENTITY(start with 1,increment by 1)时出现缺失右括号 00907. 00000 - "missing right parenthesis"错误

Question

CREATE TABLE employees
(
lastName VARCHAR2(50) NOT NULL,
employeeNumber NUMBER(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(start with 1,increment by 1) UNIQUE,
firstName varchar2(50) NOT NULL,
mobile VARCHAR(25) UNIQUE,
officeCode VARCHAR2(10) NOT NULL,
jobTitle VARCHAR2(50) NOT NULL,
birth DATE NOT NULL,
note VARCHAR2(255),
gender VARCHAR2(5),
CONSTRAINT fk_employees_officeCode FOREIGN KEY(officeCode) REFERENCES office(officeCode)
);

Answer 1

https://blog.csdn.net/fly2749/article/details/3090081