#创建表
create table s_user(
id number(6) primary key,
user_id varchar2(20),
password varchar2(20),
isdisabled number(20)
)
#创建序列
create sequence user_seq increment by 1 start with 1;
#创建触发器
create or replace trigger tr_user
before insert on s_user
for each row
begin
select user_seq.nextval into:new.id from dual;
end;