ora-02000 缺失always关键字怎么解决

Question

SQL> CREATE TABLE vegetables
2 (
3 id NUMBER(4) GENERATED BY DEFAULT AS IDENTITY,
4 name VARCHAR2(10) NOT NULL,
5 price NUMBER(3) NOT NULL,
6 city VARCHAR2(6) NULL
7 );
id NUMBER(4) GENERATED BY DEFAULT AS IDENTITY,
*
第 3 行出现错误:
ORA-02000: 缺失 ALWAYS 关键字

Answer 1

你oracle是什么版本？你这个建表语句,我在21c上测试没有报错

21c官方文档

CREATE TABLE https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6

11g官方文档

CREATE TABLE https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7002.htm#i2095331