Search notes:
ORA-32795: cannot insert into a generated always identity column
create table tq84_ora_32795 (
id integer generated always as identity,
txt varchar2(10)
);
The first insert statement runs OK, the second and third throw ORA-32795: cannot insert into a generated always identity column:
insert into tq84_ora_32795( txt) values ( 'abc');
insert into tq84_ora_32795(id, txt) values ( 2, 'def');
insert into tq84_ora_32795(id, txt) values (null, 'def');
Cleaning up
drop table tq84_ora_32795;