ANSI左连接&左连接（+） [英] ANSI left join & left join(+)

问题描述

任何人都可以帮助我知道ansi左连接和左连接与（（+））语法之间的区别吗？当一个转换为其他时，它们会产生相同的结果吗？哪一个是较旧的？

Can anyone please help me to know the difference between ansi left join and left join with ((+)) syntax?Do they produce the same results when one is converted to other?And which one is the older one?

推荐答案

Oracle的加号（+）表示法和ansi JOIN符号之间的区别？ [ ^ ]



+ 语法较旧，仅用于向后兼容。它还有一些限制，ANSI JOIN 语法没有。



Oracle推荐 [ ^ ]您只使用ANSI语法。

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

The + syntax is older, and is only included for backwards-compatibility. It also has some restrictions which the ANSI JOIN syntax doesn't have.

Oracle recommend[^] that you only use the ANSI syntax.

这篇关于ANSI左连接&左连接（+）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！