insert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) values('1','1','1','1','1','1',(select S_DEPTID.NEXTVAL FROM DUAL)) ORA-02287: 此处不允许序号???
insert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) select '1','1','1','1','1','1',S_DEPTID.NEXTVAL FROM DUAL
oracle 的自增长字段需要用触发器和序号配合使用,不能直接插入序号
语法忘了,好像insert into 后面要么全是value,要么是select ,能一些value+一些select吗?
select S_DEPTID.NEXTVAL FROM DUAL 这个出来的,不是一个值,是一列值,所以有问题
select S_DEPTID.NEXTVAL FROM DUAL 另外插入就行 插入表格的时候,values不要加括号OK
declare @DepartmentID set @DepartmentID = select S_DEPTID.NEXTVAL from dualinsert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) values('1','1','1','1','1','1',@DepartmentID) 混淆的写的SQL的语法,不记得oracle语法该怎么写了
直接去掉你sql中的values就可以了
就像这样:insert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) (select '1','1','1','1','1','1', S_DEPTID.NEXTVAL FROM DUAL)
insert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) select '1','1','1','1','1','1',S_DEPTID.NEXTVAL FROM DUAL
另外插入就行
插入表格的时候,values不要加括号OK
set @DepartmentID = select S_DEPTID.NEXTVAL from dualinsert into XT_DepartmentSet(D_SortID,D_Name,D_Tel,D_Fax,D_Higher,D_Description,DepartmentID) values('1','1','1','1','1','1',@DepartmentID) 混淆的写的SQL的语法,不记得oracle语法该怎么写了