1.SYS_GUID函数INSERT INTO TEST (ID,NAME) VALUES(SYS_GUID(),'SS');2.创建序列create sequence TEST_INDEXminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1nocache;INSERT INTO TEST (ID,NAME) VALUES(TEST_INDEX.NEXTVAL,'SS2');如果插入关联表的主键可以使用INSERT INTO TEST (ID,NAME) VALUES((SELECT DEPTNO ID