建表语句
create table Student(
StuId NUMBER NOT NULL, --学生ID
StuName VARCHAR2(10) NOT NULL, --名称
Gender VARCHAR2(10)NOT NULL, -- 性别
Age NUMBER(2) NOT NULL, -- 年龄
JoinDate DATE NULL, --入学时间
ClassId NUMBER NOT NULL, --班级ID
Address VARCHAR2(50) NULL --家庭住址
);
如何使学生ID自增长?
创建序列
create sequence seq_id_emps
minvalue 1000
maxvalue 9999
start with 1001
increment by 1
cache 50
创建触发器
create trigger "emps_trig"
before insert on emps
referencing old as old new as new for each row
declare
begin
select seq_id_emps.nextval into :new.id from dual;
end emps_trig;