create
sequence
TELLER
.
LOGIN_HISTORY_SEQ
minvalue
1
nomaxvalue
start
with
1
increment
by
1
cache
20
nocycle;
创建插入数据的触发器
create
or
replace
trigger
"trigger1"
before
insert
on
user_login_history
referencing
old
as
old
new
as
new
for
each
row
declare
begin
select
TELLER
.
LOGIN_HISTORY_SEQ
.nextval
into:new.
login_number
from
dual
;
end
"trigger1"
;
