java.sql.SQLException: ORA-02289: sequence does not exist

来源:互联网 发布:linux vsftpd rpm下载 编辑:程序博客网 时间:2024/05/30 05:15

创建序列SQL(已经解决)


create sequence nuser_seq

minvalue 1
maxvalue 999999999999999999
start with 1
increment by 1

cache 20;


创建触发器




create or replace trigger userman
before insert on supplier.userman
for each row
begin
select seq_userman.nextval into :user_id from dual;
end;

原创粉丝点击