我的SEQ是这样:
SQLWKS> desc seq
Column Name Null? Type
------------------------------ -------- ----
SEQUENCE_NAME NOT NULL VARCHAR2(30)
MIN_VALUE NUMBER
MAX_VALUE NUMBER
INCREMENT_BY NOT NULL NUMBER
CYCLE_FLAG NOT NULL VARCHAR2(1)
ORDER_FLAG NOT NULL VARCHAR2(1)
CACHE_SIZE NOT NULL NUMBER
LAST_NUMBER NOT NULL NUMBER
create or replace TRIGGER TableName_insert
before insert on TableName
for each row
declare
i_id integer;
begin
select seq_a.nextval into i_id from dual;
:NEW.user_id := i_id;
end;