给B表加一个ID列,给ID建一个序列,让ID列自动增加,把ID列设成主键不就成了吗 1.**************建序列 CREATE SEQUENCE PK_SEQ INCREMENT BY 1 START WITH 1 NOCYCLE NOCACHE; 2.*******************建一个insert触发器 CREATE OR REPLACE TRIGGER TRG_seq Before Insert On stud For Each Row declare L_SQ number; Begin Select PK_SEQ.NextVal Into L_SQ From Dual; :New.stud_no:=L_SQ; End; 3.***************** insert into 表名 values(null,值2,值3,值4);
1.**************建序列
CREATE SEQUENCE PK_SEQ
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
2.*******************建一个insert触发器
CREATE OR REPLACE TRIGGER TRG_seq
Before Insert On stud For Each Row
declare
L_SQ number;
Begin
Select PK_SEQ.NextVal Into L_SQ From Dual;
:New.stud_no:=L_SQ;
End;
3.*****************
insert into 表名 values(null,值2,值3,值4);