==== Identity Columns ==== Force use of identity, generate error if statement references identity column CREATE TABLE test_table ( id NUMBER GENERATED ALWAYS AS IDENTITY, description VARCHAR2(40) ); If statement references identity column then use that value.\\ Use the identity value if the column isn't referenced.\\ Cannot use null value. CREATE TABLE test_table ( id NUMBER GENERATED BY DEFAULT AS IDENTITY, description VARCHAR2(40) ); If statement references identity column then use that value. \\ Use the identity value if the column isn't referenced. \\ Can use a null value. CREATE TABLE test_table ( id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, description VARCHAR2(40) ); Start the identity number with 100 and increment each value by 10 CREATE TABLE test_table ( id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 100 INCREMENT BY 10), description VARCHAR2(30) );