1.创建表
create table t_user (
id number(10),
name varchar2(20) not null,
phone_Number varchar2(20),
email_Address varchar2(200) not null,
home_Address varchar2(200) not null,
constraint pk_user primary key (id)
);
2.创建序列
create sequence t_user_id_seq start with 1 increment by 1;
#查看序列
select * from user_sequences;
3.创建触发器
create or replace trigger t_user_trigger
before insert on t_user
for each row
when(new.id is null)
begin
select t_user_id_seq.nextval into:NEW.ID from dual;
end;
#查看触发器
select * from user_triggers;