使用出现SP2-0042: unknown command "INTERSECT" - rest of line ignored.相同的错误还有
SP2-0042: unknown command "UNION" - rest of line ignored.
SP2-0042: unknown command "MINUS" - rest of line ignored.SQL*Plus: Release 11.1.0.7.0是不支持这类操作吗?
新手飘过
SP2-0042: unknown command "UNION" - rest of line ignored.
SP2-0042: unknown command "MINUS" - rest of line ignored.SQL*Plus: Release 11.1.0.7.0是不支持这类操作吗?
新手飘过
oracle是支持这个 集合操作运算符的,你要贴出你的sql代码出来,这样大家才好分析啊。
CREATE TABLE TEMP11 as
SELECT rID
FROM Researcher, WrittenBy, PublishedIn
WHERE Researcher.rID = WrittenBy.rID = PublishedIn.rID
INTERSECT
SELECT rID
FROM Researcher, EditedBy
WHERE Researcher.rID = EditedBy.rID;有什么错吗?
SELECT rID
FROM Researcher, WrittenBy, PublishedIn
WHERE Researcher.rID = WrittenBy.rID = PublishedIn.rID
INTERSECT
SELECT rID
FROM Researcher, EditedBy
WHERE Researcher.rID = EditedBy.rID;条件中不能用连“=”号,应用and连接
红色部分改为:
Researcher.rID = WrittenBy.rID AND WrittenBy.rID = PublishedIn.rID
SELECT rID
FROM Researcher, WrittenBy, PublishedIn
WHERE Researcher.rID = WrittenBy.rID = PublishedIn.rID
INTERSECT
SELECT rID
FROM Researcher, EditedBy
WHERE Researcher.rID = EditedBy.rID;条件中不能用连“=”号,应用and连接
红色部分改为:
Researcher.rID = WrittenBy.rID AND WrittenBy.rID = PublishedIn.rID
谢谢,结贴咯。