Create and use a surrogate primary key
create sequence pk_seq nocache;
create or replace trigger tib_insert_test
before insert on insert_test
referencing new as new old as old
for each row
begin
select
pk_seq.nextval
into
:new.id
from
dual;
end tib_insert_test;
before insert on insert_test
referencing new as new old as old
for each row
begin
select
pk_seq.nextval
into
:new.id
from
dual;
end tib_insert_test;
insert into insert_test (remarks)
select object_name from all_objects;
select object_name from all_objects;