blocks|key|1492910|text|Oracle10(我相信是11)仍然支持这种表示法。它的使用被认为是“老式的”，而且也不像ANSI+JOIN语法那样具有数据库可移植性。它也被认为可读性差得多，尽管如果你来自%2B背景，习惯ANSI连接可能需要一点时间。在向Oracle扔砖头之前要知道的重要一点是，他们在ANSI委员会完成连接的定义之前就开发了%2B语法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1492911|没有性能差异；它们表达的是相同的东西。|1492912|编辑：“不能移植”我应该说“只在Oracle+SQL中支持”|1492913|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

The notation is still supported as of Oracle 10 (and I believe 11). It's use is considered "old fashioned", and also is not as database portable as the ANSI JOIN syntax. It's also considered much less readable, although if you come from the + background getting used to ANSI JOIN can take a little time. The important thing to know before hurling brickbats at Oracle is that they developed their + syntax before the ANSI committee had completed the definitions for the joins.

There is no performance difference; they are expressing the same thing.

Edit: By "not as portable" I should have said "only supported in Oracle SQL"

blocks|key|1492940|text|我使用(%2B)表示法，因为几乎所有与Oracle+Apps+r12相关的查询都基于此。在Oracle应用程序查询中(甚至是Oracle自己提供的查询)，我还没有看到一个带有标准"join“表达式的SQL查询。如果你不相信我，就用谷歌搜索任何与甲骨文应用相关的信息。例如：Fixed+assets+related+queries|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1492941|entityMap|0|LINK|mutability|MUTABLE|url|http://aksenthil.blogspot.com/2009/02/fa-for-getting-ytd-depreciationetc.html^0|3Q|S|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I use (+) notation, because almost all of the Oracle Apps r12 related queries are based on that. I've not seen a single SQL query with a standard "join" expression in Oracle APPS queries(even the ones provided by Oracle itself). If you don't believe me, simply google any Oracle apps related information. For example: <a href="http://aksenthil.blogspot.com/2009/02/fa-for-getting-ytd-depreciationetc.html" rel="nofollow">Fixed assets related queries</a>

blocks|key|1492963|text|最全面的答案显然是nagul的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1492964|对于那些正在寻找ANSI语法的快速转换/映射的人：|1492965|--
--+INNER+JOIN
--
SELECT+*
FROM+EMP+e
INNER+JOIN+DEPT+d+ON+d.DEPTNO+=+e.DEPTNO;

+--+Synonym+in+deprecated+oracle+(%2B)+syntax
SELECT+*
FROM+EMP+e,
+++++DEPT+d
WHERE+d.DEPTNO+=+e.DEPTNO;

--
--+LEFT+OUTER+JOIN
--
SELECT+*
FROM+EMP+e
LEFT+JOIN+DEPT+d+ON+d.DEPTNO+=+e.DEPTNO;

+--+Synonym+in+deprecated+oracle+(%2B)+syntax
SELECT+*
FROM+EMP+e,
+++++DEPT+d
WHERE+d.DEPTNO+(%2B)+=+e.DEPTNO;

--
--+RIGHT+OUTER+JOIN
--
SELECT+*
FROM+EMP+e
RIGHT+JOIN+DEPT+d+ON+d.DEPTNO+=+e.DEPTNO;

--+Synonym+in+deprecated+oracle+(%2B)+syntax
SELECT+*
FROM+EMP+e,
+++++DEPT+d
WHERE+d.DEPTNO+=+e.DEPTNO(%2B);

--
--+CROSS+JOIN
--
SELECT+*
FROM+EMP+e
CROSS+JOIN+DEPT+d;

+--+Synonym+in+deprecated+oracle+(%2B)+syntax
SELECT+*
FROM+EMP+e,
+++++DEPT+d;

--
--+FULL+JOIN
--
SELECT+*
FROM+EMP+e
FULL+JOIN+DEPT+d+ON+d.DEPTNO+=+e.DEPTNO;

--+Synonym+in+deprecated+oracle+(%2B)+syntax+!NOT+WORKING!
SELECT+*
FROM+EMP+e,
+++++DEPT+d
WHERE+d.DEPTNO+(%2B)+=+e.DEPTNO(%2B);|code-block|syntax|javascript|1492966|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/1193722/1845976^0|9|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

The most comprehensive answer obviously is the one by <a href="https://stackoverflow.com/a/1193722/1845976">nagul</a>.

An addition for those who are looking for quick translation/mapping to the ANSI syntax:

<pre><code>--
-- INNER JOIN
--
SELECT *
FROM EMP e
INNER JOIN DEPT d ON d.DEPTNO = e.DEPTNO;

 -- Synonym in deprecated oracle (+) syntax
SELECT *
FROM EMP e,
 DEPT d
WHERE d.DEPTNO = e.DEPTNO;

--
-- LEFT OUTER JOIN
--
SELECT *
FROM EMP e
LEFT JOIN DEPT d ON d.DEPTNO = e.DEPTNO;

 -- Synonym in deprecated oracle (+) syntax
SELECT *
FROM EMP e,
 DEPT d
WHERE d.DEPTNO (+) = e.DEPTNO;

--
-- RIGHT OUTER JOIN
--
SELECT *
FROM EMP e
RIGHT JOIN DEPT d ON d.DEPTNO = e.DEPTNO;

-- Synonym in deprecated oracle (+) syntax
SELECT *
FROM EMP e,
 DEPT d
WHERE d.DEPTNO = e.DEPTNO(+);

--
-- CROSS JOIN
--
SELECT *
FROM EMP e
CROSS JOIN DEPT d;

 -- Synonym in deprecated oracle (+) syntax
SELECT *
FROM EMP e,
 DEPT d;

--
-- FULL JOIN
--
SELECT *
FROM EMP e
FULL JOIN DEPT d ON d.DEPTNO = e.DEPTNO;

-- Synonym in deprecated oracle (+) syntax !NOT WORKING!
SELECT *
FROM EMP e,
 DEPT d
WHERE d.DEPTNO (+) = e.DEPTNO(+);
</code></pre>

What's the difference between using oracle's plus notation <code>(+)</code> over the ansi standard <code>join</code> notation?

Is there a difference in performance?

Is the plus notation deprecated?

Difference between Oracle's plus (+) notation and ansi JOIN notation?

数据库

与ansi标准join符号相比，使用oracle的加号符号(+)有什么不同？在性能上有区别吗？加号表示法是否已弃用？

问Oracle的加号(+)表示法和ansi连接表示法之间的区别？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle的加号(+)表示法和ansi连接表示法之间的区别？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle的加号(+)表示法和ansi连接表示法之间的区别？
EN