Oracle数据库一些操作
标签：
Oracle数据库一些操作
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" ;