Create a table and auto-increment primary key in Oracle

Create a table in Oracle and an auto-increment table in primary key: create table tuser (id number (11) not null, name varchar2 (20) not null, password varchar2 (20), birthday date, constraint tuser_pk primary key (id); create sequence: create sequence increase_seq increment by 1 start with 1 nomaxvalue nocycle cache 10; create trigger: create or replace trigger tuser_triggerbefore insert on tuser for each rowbeginselect increase_seq.nextval into: new. id from dual; end; /According to the tool used, you may need to add "/" to execute PL/SQL blocks. Test: insert into tuser (name, password, birthday) values ('wujay ', '000000', null); commit; select * from tuser; id name password birthday ---------- -------------------- -------------- 1 wujay 123456 modify the table: alter table tuser rename column id to pk_tuser;