ORACLE创建主键自增表

来源：互联网发布：java redis消息队列编辑：程序博客网时间：2024/05/22 12:53

--创建表，设置主键自增

Create Table stu(uerId NUMBER(4) Not Null Primary Key,username Varchar(20),userpass Varchar(20),email varchar2(30),grade NUMBER(5));Commit;

--小查一下

Select * From STU;

--创建主键自增序列

Create Sequence emp_sequenceIncrement By 1Start With 1NomaxvalueNocycleNocache;Commit;

--创建触发器

Create Trigger "trigger_on_STU" BeforeInsert On STU For Each Row When (New.uerId Is Null)BeginSelect emp_sequence.Nextval Into :New.uerId From dual;End;

--插入数据

Insert Into STU(username,userpass,email,grade) Values('admin','admin','admin@admin.com',1);Insert Into STU(username,userpass,email,grade)  Values('dhy','dhy','dhy@admin.com',1);Insert Into STU(username,userpass,email,grade)  Values('nsr','nsr','nsr@admin.com',1);Insert Into STU(username,userpass,email,grade)  Values('adamin','addmin','admdin@admin.com',5);Insert Into STU(username,userpass,email,grade)  Values('dhay','dhay','dhay@admin.com',3);Insert Into STU(username,userpass,email,grade)  Values('ansr','ansr','ansr@admin.com',4);Commit;

--查看数据

Select * From STU;