(+)在Oracle SQL中有什么作用? [英] What does (+) do in Oracle SQL?

问题描述

我正在使用Oracle SQL Developer查询Oracle DB(不确定它是哪个版本)，并且将要使用为Crystal报表制作的SQL.以前的开发人员编写的许多报告都不使用JOIN关键字进行联接(因此，我对JOIN关键字不太熟悉).

I'm using Oracle SQL Developer to query an Oracle DB (not sure which version it is) and I'm going to use the SQL I make for a Crystal report. Many of the reports the previous developers have written don't use JOIN keywords to make the joins (and I'm not too familiar with JOIN keywords as a result).

它们进行的许多联接都是在WHERE语句中进行的.我会注意到这样的事情.

Many of the joins they make are made in the WHERE statement. I'll notice something like this.

Select * From TableA, TableB WHERE TableA.PrimaryKey(+) = TableB.ForeignKey

我的问题与(+)有关.它有什么作用?如何在代码中使用它?

My question is concerning the (+). What purpose does it serve and how do I use it in my code?

推荐答案

不推荐.查看以前的答案

It is not recommended. See this previous answer

Oracle的加号(+)表示法与ansi JOIN之间的区别记号?

这篇关于(+)在Oracle SQL中有什么作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！