ora-02000 缺失always关键字怎么解决
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 关键字
你oracle是什么版本？你这个建表语句,我在21c上测试没有报错
