Table:
CREATE TABLE TEST_A
(
ID NUMBER NOT NULL,
NAME CHAR(200),
ADDRESS CHAR(200),
CONSTRAINT ID PRIMARY KEY (ID)
)
Sequence:
create sequence S_TEST_A
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;
Trigger:
create or replace trigger "test_a_trigger" before
insert on TEST_A for each row
when (new.id is null)
begin
select S_TEST_A.nextval into:new.id from dual;
end;