Navicat 或Plsql中插入数据时ID插入方式

1.SYS_GUID函数

INSERT INTO TEST (ID,NAME) VALUES(SYS_GUID(),'SS');

2.创建序列

create sequence TEST_INDEX
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache;

INSERT INTO TEST (ID,NAME) VALUES(TEST_INDEX.NEXTVAL,'SS2');

如果插入关联表的主键可以使用

INSERT INTO TEST (ID,NAME) VALUES((SELECT DEPTNO ID FROM DEPT  WHERE DNAME='SALES'),'SS3');