“！="之间有什么区别吗?和“<>"在Oracle Sql中? [英] Is there any difference between "!=" and "<>" in Oracle Sql?

问题描述

我想知道Oracle中两个not equal运算符<>和!=之间是否存在任何差异.

I would like to know if there are any differences in between the two not equal operators <> and != in Oracle.

在某些情况下它们可以给出不同的结果或不同的性能吗?

Are there cases where they can give different results or different performance?

推荐答案

在功能上完全没有区别.
(所有其他DBMS都是一样的-大多数都支持两种样式):

No there is no difference at all in functionality.
(The same is true for all other DBMS - most of them support both styles):

这是当前的SQL参考: https://docs.oracle.com/database/121/SQLRF/conditions002.htm#CJAGAABC

Here is the current SQL reference: https://docs.oracle.com/database/121/SQLRF/conditions002.htm#CJAGAABC

SQL标准仅为"不等于"定义单个运算符，即<>

The SQL standard only defines a single operator for "not equals" and that is <>

这篇关于“！="之间有什么区别吗?和“<>"在Oracle Sql中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！