新建一张部门表 字段为ID 默认1000开始 每次增加2 为主键 整型 部门编码 varchar

创建2个序列
create sequence DEPART_ID
minvalue 1
maxvalue 99999
start with 1000
increment by 2
cache 4000
cycle;
create sequence COM_ID
minvalue 1
maxvalue 99999
start with 1000
increment by 1
cache 4000
cycle;

表
create table company
( id number primary key,
com_id varchar2(50),
com_name varchar2(50)
)

create table depart
( id number ,
depart_id varchar2(50),
depart_name varchar2(50),
com_id number
)
foreign key (com_id) references com_id(id)

然后插入数据的时候company表id填入COM_ID.nextval，depart表填入DEPART_ID.nextval就好

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/vrfferxv7xjyve73yjx.html