- Log in to post comments
create table NEW_TABLE(id number, testdata varchar2(255));
create sequence NEW_TABLE_SEQ
start with 1
increment by 1
nomaxvalue;
create trigger NEW_TABLE_TR
before insert on NEW_TABLE
for each row
begin
select NEW_TABLE_SEQ.nextval into :new.id from dual;
end;